Lining up scales on primary and secondary y axes

G

Guest

Hello

I have a column chart that includes a secondary y axis. The values on the
primary axis range from zero to 160,000. The values on the secondary axis
range from minus 20% to plus 30%.

The problem is that the zero values on the two scales do not appear along
the same horizontal line on the chart. The zero value on the secondary axis
is on the same horizontal level as $60,000 on the primary axis.

How can I change this so that the zero values on both axes line up
 
G

Guest

Thanks Andy,

I managed to come up with a simple fix to my problem just by adjusting the
minimum value on the scale of the primary axis. Maybe not the best solution
but if it works then you have got to be happy....
 

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

Custom EXCEL chart value axis BRAIN TEASER 1
Secondary axes issues 2
Charting on Primary & Secondary Axis - Zero Point Does Not Align 1
Can't get the x-axis to cross at value 0 for both y-axes 3
align zero markers on combination chart? 2
Coordinate secondary y axis to primary y axis 2
Switch Primary and Secondary Y Axes 10
Swap Y-Axis numbers 3

Top