Changing a chart scale using a formula/macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/
_______
 
Thanks,
Doug

Jon Peltier said:
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/
_______
Click to expand...
 
Back
Top