Autoadjusting Y axis minimum

[Guest]

I want the axis to adjust to 2/3 of the lowest value in my
chart. How do I get my minimum to change? When I set it
to auto it just starts at 0.

 

[Tushar Mehta]

You have to do it programmatically. Jon Peltier has shared code on the
subject. Search google.com's archives of the XL newsgroups. 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]

Here's the web page:

http://www.geocities.com/jonpeltier/Excel/Charts/AxisScaleLinkToSheet.html

- Jon