Secondary Axis not crossing at zero

G

Guest

I have a chart with a primary and secondary axis.

Values for the primary axis range from 0 to 260, values for the secondary
axis range from -50% to 50%.

I would like to have the zeros on both axis line up, so that the negative
percentages on the secondary axis are clearly identifiable. I can't find a
way to do it.

In the default chart, the x axis crosses the primary y-axis at 0, but the 0
on the secondary y-axis is at approximately the same height as the value 50
on the primary axis.

Please help!
Astrid
 
D

David Biddulph

Right-click on an axis. Format Axis/ Scale. Alter the min and max values
to suit your requirements. Can also set the value at which the X-axis
crosses.
 
G

Guest

I did try that and those boxes are checked (axis crosses at 0), but the zero
on the primary and secondary y-axis don't line up.

I did manipulate the minimum and maxiumum values and got the zeros to line
up, but now the bars in the bar chart associated with the primary y-axis
actually start below the 0 even though all the values are greater than 0.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't get the x-axis to cross at value 0 for both y-axes 3
Coordinate secondary y axis to primary y axis 2
Primary X axis to Secondary X axis 1
Secondary axis not aligning to X axis 1
How do I change where category x axis crosses the 2nd y axis? 7
Chart distorts secondary axis when the x-axis is logarithmic 5
Custom EXCEL chart value axis BRAIN TEASER 1
Charting on Primary & Secondary Axis - Zero Point Does Not Align 1

Top