changing chart scale with VBA

[luv2glyd]

How would I change a chart's scale with VBA? Right now I have the following:

Please Login or Register  to view this content.

and would like to do this without excel physically selecting the chart (first line of code, but have it simply change the value of max and min.

Thank you.

[Rubeus_Hagrid]

Hi,

Following code is working fine with my chart. Hope it would be useful for you as well.

Public Sub mychart()
Dim thechart As ChartObject

Set thechart = Sheet1.ChartObjects("Chart 1")
thechart.Chart.Axes(xlValue).MinimumScale = 6
thechart.Chart.Axes(xlValue).MaximumScale = 26

End Sub

[luv2glyd]

That works! Thank you.

[shg]

Rubeus,

Please read the Forum Rules, and wrap code with Code Tags.