adjusting Y-axis

[P. van de Zwalum]

I have to make charts according an ISO-qualification. The Y-axis has to go
from bottom to top with a difference of 50, for instance from 0 to 50 or 20
to 70, this adjusting has to go automatically.
As far as I know the adjusting goes automatically by the data, when the data
exceeds the 50, the adjusting goes bigger than 50, and then the the chart
isn't according the ISO.

 

[Tushar Mehta]

There has to be a misinterpretation of the ISO standard. Clearly, no
standard for a generic chart can indicate that the range of the y-
values has to be exactly 50 units!

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Regardless, there are reasons one may want this scaling. Using Tushar's
AutoChart addin (http://tushar-mehta.com) or the process described on my
web site:

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

you could keep a constant range from axis min to max.

- Jon