Changing a chart scale using a formula/macro
 

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

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 wrote:

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

Thanks,
Doug

"Jon Peltier" wrote:

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 wrote:

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