Value Axis Excel 2003 - Aligning to zero

[tennisboy]

Hi,

Sorry for my second post of the day, I ahve to value axis (Value Axis and Secondary Value Axis) - both axis are percentages but have different scales, is there a way of aligning both scales to zero, currently one is further right than the other....

thanks again

Mart

 

[Andrew Poulsom]

Can't you change the scale on one of the axes so that they line up (right click, Format Axis, Scale tab)?

 

[tennisboy]

thanks for the quick reply, I did think of that and am trying to do it but its proving quite tricky, was wondering if there was another way....

Thanks

Mart

 

[Jon Peltier]

You might read this article:

Align X Axis to Y=0 on Two Y Axes