Lining up scales on primary and secondary y axes

M

MarkN

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
 
M

MarkN

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

Automatic Way to have Equal Scales on X-Y Plots ? 0
Secondary axes issues 2
Charting on Primary & Secondary Axis - Zero Point Does Not Align 1
Coordinate secondary y axis to primary y axis 2
align zero markers on combination chart? 2
Custom EXCEL chart value axis BRAIN TEASER 1
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Primary X axis to Secondary X axis 1

Top