Y-Axis maximum based on data range

[Jay]

How can I make Excel to choose the maximum value on the Y-
axis to chart to be based on the maximum value in the data
range? In other words, if the maximum value in my data
range (for Y-axis) is 14%, then I want the Y-axis maximum
value to be automatically set at 14% on the chart. Again,
since the values in the data range may change, I want the
maximum value to be chosen dynamically.

Any help would be greatly appreciated.

Thanks,
Jay

 

[Frank Kabel]

Hi Jay

have a look at
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Frank

 

[Tushar Mehta]

The only way to change the min/max values of a chart automatically is
with a programmatic solution. Search the google.com archives of this
newsgroup for code on the subject. For a readymade solution, check the
'AutoChart Manager' add-in, available from my web site.

--
Regards,

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

 

[Jon Peltier]

Actually, that page won't help, but this one describes the process which
Tushar's addin does automatically:

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

- Jon