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