Y-Axis maximum based on data range

  • Thread starter Thread starter Jay
  • Start date Start date
J

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
 
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
 
Back
Top