Autoadjusting Y axis minimum

  • Thread starter Thread starter Guest
  • Start date Start date
G

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