Changing a chart scale using a formula/macro

[Doug]

Is it possible to change the scale (min & max of the Y axis) of a chart
using a formula or macro. I need to be able to apply this to about 20
different sets of min & max numbers on the same chart.

Thanks,
Doug

 

[Jon Peltier]

Doug -

The code is like this:

With ActiveChart.Axes(2,1)
.MinimumScale = <new minimum>
.MaximumScale = <new maximum>
End With

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

 

[Doug]

Thanks,
Doug

Doug -

The code is like this:

With ActiveChart.Axes(2,1)
.MinimumScale = <new minimum>
.MaximumScale = <new maximum>
End With

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