Is variable chart scale possible?

  • Thread starter Thread starter Brian Davies
  • Start date Start date
B

Brian Davies

I would like to know if it is possible for the axis scales on a chart t
be variable, without using auto-scaling.

In other words, for each axis, I want the Minumum, Maximum, and Majo
Unit to be the values of three particular cells in the worksheet. I
would be ideal if I could simply put the cell addresses in the field
for the min, max and major unit instead of just values, but this doe
not seem to be possible. Is there any way around this?

Thanks
 
The only way to link the max/min axis values to cells is through code.
For a free add-in check the AutoChart Manager, available from my web
site.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2004
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 
I've recently posted some instructions on my web site:

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

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

Jon said:
Brian -

I posted some sample code to do this:

http://www.google.com/groups?selm=#SkS6#$RCHA.3736@tkmsftngp11

For a self-contained method, check out the AutoChart manager on Tushar
Mehta's web site, http://www.tushar-mehta.com

- Jon
Click to expand...
 
Back
Top