Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Chart scale & paper size | New Users to Excel | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
Cell value as chart scale maximum | Charts and Charting in Excel | |||
Changing chart orientation | Charts and Charting in Excel |