Autoadjusting Y axis minimum

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- 15 Dec 2003 19:07 GMT

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.

Reply to this Message

Tushar Mehta - 15 Dec 2003 23:11 GMT

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.

Signature

Regards,

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

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

Reply to this Message

Jon Peltier - 16 Dec 2003 16:55 GMT

Here's the web page:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

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

Reply to this Message