Value (Y) axis crosses between categories and Secondary Value (Y) Axis


    Sponsored Links


  • 1. I would like to make a schedule for my dept. Who works what days .
    I am supervisor for a nursing dept. I need to make a schedule for them to follow as to who works when and what shift. I need to be sure they all get the hours that they are required to work. Is there a template that would help me and be able to sort things out in the schedule as well?
  • 2. Need large gap in chart
    I am making a line graph with 2 sets of numbers that are very far apart - one set of numbers is around 7000 to 8000, and the other set is closer to 80,000. Of course, I get one line at the top of the chart that is pretty easy to read, but the line on the bottom that represents the smaller numbers is just TINY and looks pretty much straight. My question is this: is there a way to put a "break" into the graph between the smaller numbered data and the larger ones so they are all easier to read? Like a jagged line showing where the jump occurs or something?
  • 3. Plotting different length series in a chart
    I have a series of data that extends for 12 months and another series that extends for 4 months. Plan vs actual. The actual series continues at a zero value after the data ends. Is there a way to chart only the 4 months on one series while the full 12 months is charted on the other series?
  • 4. how to prepare 3 dimension graph in excel
    I am trying to draw a graph in X, Y, Z axis but cant get throught, I was sucessful in drawing in two axis X,Y can any one help me in this.
  • 5. How do i create a log graph in excel
    Is there any way of creating a log graph within excel?

Value (Y) axis crosses between categories and Secondary Value (Y) Axis

Postby -markc » Sun, 28 Oct 2007 07:30:37 GMT

Hi all -

I have 7 series on my chart
Series 1 is column chart - may be area chart eventually (2007 data)
Series 2 is column chart 2008 data
Series 3 is column chart 2007 avg
Series 4 is a column chart 2008 avg
Series 5 is a line chart (32,0 benchmark)
Series 6 is a line chart (points to column chart for 2007 avg, I then
add text to right to explain the column)
Series 7 is a line chart (points to column chart for 2008 avg, I then
add text to right to explain the column)

I would like the column charts for 2007 and 2008 data to be flush to
the origin (12 data points each year)
I would like the benchmark line chart of 32 to span the chart area
from left to right (16 data points)

mark from Value (Y) axis crosses between categories when formatting
the x axis.

However, when I do that, the data point for 2007 closest to the origin
appears cut-off on left side of column

I more or less posted this information on Ozgrid a few days ago
(Ozgrid is now down until Nov. 13 according to the site). Andy Pope
replied that if I move the line charts to the Secondary Value (Y)
Axis, that would resolve the problem.

I must be doing something wrong. I did assign the line chart to
Secondary Value (Y) Axis and then cleared the tick mark on the x axis:
Value (Y) axis crosses between categories. However whatever datapoint
is closest to the Primary Y Axis disappears entirely

What am I doing wrong here?
Send a confidential e-mail for a sample copy of the workbook
Best regards,

Re: Value (Y) axis crosses between categories and Secondary Value (Y) Axis

Postby Jon Peltier » Mon, 29 Oct 2007 09:33:23 GMT

To draw a line on a chart, use a technique like this:


- Jon
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -  http://www.**--****.com/ 

Re: Value (Y) axis crosses between categories and Secondary Value (Y) Axis

Postby -markc » Fri, 02 Nov 2007 04:03:23 GMT

On Oct 27, 5:33 pm, "Jon Peltier" < XXXX@XXXXX.COM >

Thanks Jon
Works great
Appreciate the help

Best regards

Similar Threads:

1.Need PivotChart x axis to cross Y axis at minimum Y axis value

I see an option to have x cross y at max y, but how can I say min y?

2.chart secondary axis crossing with x axis

I have a series of VBA generated plots with dual axes.
The data charted is best represented with a logprimary axis scale and a
log secondary axis scale.

For most datasets this is fine, and has the left/primary axis marker
'1' aligned horizontally with the right/secondary axis marker '0'; all
correct and how I want it it.

However, when an original value is less than 1, the primary log axis
responds appropriately by adding another log unit ('0.1') to
accommodate the data. The problem the plot then has is that this new
minimum on the primary log scale is aligned horizontally with the
right/secondary axis marker '0', which is not correct at all.

How can I code that the minimum axis value on the secondary axis (which
is invariably zero) will always align horizontally with the value 1 on
the primary log axis, regardless of how many log units this primary
axis requires?

Thanks in advance for your suggestions.


3.Setting "Value (Y) axis crosses between categories"


I am trying to find out how to duplicate a specific 
property in a Web based OWC chart generator that you can 
set in an Excel chart.

-If you create a line chart in excel
-Then Select the X Axis
-Then from "Format" (or right click) select "Format 
(Selected) Axis"
-Go to the Scale Tab of the "Format Axis" Dialog
-Then There is a checkbox that is labled "Value (Y) axis 
crosses between categories"

If the "Value (Y) axis crosses between categories" box is 
checked the first and last series do not sit on the 
borders of the chartspace but instead are padded to the 
center of each category.

In Excel the 
property "Microsoft.Office.Interop.Excel.Axis.AxisBetweenC
ategories" can be set to "true" or "false", but this 
property does not exist 
in "Microsoft.Office.Interop.OWC.ChAxis".

I have tried working with the "Crosses" property of 
the "chAxis" object ("Crosses" Set 
to "chAxisCrossesCustom" and then setting 
the "CrossingAxis" and "CrossingAtValue" property) but 
this seemed ot have no effect other than moving the Y-
axis from left to right across the chart.

Does anyone have any insight to this? Is there something 
in the series instead?


David Smith

4.Secondary y-axis for certain x-axis categories (not by series)


I have the data set up similar to this:

              Group 1          Group 2          Group 3
A                1                 1.5                  0.8
B                5                 3.2                  2.5
C                4                 6.7                  4
D               $35              $20                  $56
E               $42               $36                 $29

I want to put all three series into one bar chart with categories A, B, C, 
D, E across the x-axis.  I want to have 2 y-axes, one for categories A, B, C 
and one for categories D & E.  However, when I use the "Secondary Axis" 
option, it seems to only allow me to choose a series (Group 1, Group 2, or 
Group 3) for the secondary axis.  Is there a method to use the Secondary Axis 
feature wtih x-axis categories (and not with a data series)?

Thank you!


5.Using a cell reference as the axis value for Horizontal axis crosses

Is there any way of referencing a cell as the value in the "axis
value" area of the "Format Axis dialog box. I am currently entering a
number i.e. 2.5. I would like to be able to have this number change
when a user enterer a value in a cell?  Would it have to be VBA code
or is there another way?

6. Can't get the x-axis to cross at value 0 for both y-axes

7. X-axis to cross Y-axis at avrg Y-value

8. Change Value axis to category axis

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 33 guest