Link cell to axis maximum and mininum

[Guest]

Hi

I have a big number of charts that I would like to change the X-axis maximun and minimum values in an easy way. It would be perfect just to asign e.g. the maximum value to a worksheet cell. Is it possible in any other way to change the chart axis max and min value for more than one chart at a time

Best Regard
Peter

 

[Frank Kabel]

Hi
have a look at the following site for an add-in that will achieve this
http://www.tushar-mehta.com/excel/software/autochart/index.html

 

[Guest]

It worked

Thank you Frank

Regard
Pete
Linköping, Sweden

 

[Tushar Mehta]

Unfortunately, you have to use a programmatic solution for the problem.
For a ready made 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]

The process is described on this web page:

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

- Jon