How do I use an indirect reference for a chart scale in Excel?

[Guest]

I am tired of manually entering MIN and MAX values for the X-axis in and
Excel chart. I would rather have these values calculated as part of a
worksheet and have these cells values used on the SCALE tab of the Format
dialogue. Is this possible?

 

[Jon Peltier]

Professor -

You need to use VBA, but it's possible. Here's the technique, described
on my web site:

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

and here's a self-contained add-in that handles the nasty details for
you, Tushar Mehta's AutoChart Manager:

http://tushar-mehta.com/excel/software/autochart/index.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[dh13134]

If I want to share this file with someone else, do they need the add-in for
the chart scaling to funcion properly?
Thanks

 

[Tushar Mehta]

Yes, the addin -- as with any other addin -- has to be on each
computer.

If I want to share this file with someone else, do they need the add-in for
the chart scaling to funcion properly?
Thanks

Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins