How do I change a Chart's axis scale from visual basic?

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

Guest

How do I change a Chart's (that is on a worksheet) x-axis scale from visual
basic?

The following only works when the chart has its own sheet/tab.
With Charts("Chart1").Axes(xlCategory)
.MinimumScale = 740.25
.MaximumScale = 746.25
End With

If it is located within a worksheet how do you reference it?
 
Hi,

Some more like this for chartobject,

With ActiveSheet.ChartObjects("Chart 1").Chart.Axes(xlCategory)
.MinimumScale = 740.25
.MaximumScale = 746.25
End With

Cheers
Andy
 
Thanks a bunch.
Excellent.
John

Andy Pope said:
Hi,

Some more like this for chartobject,

With ActiveSheet.ChartObjects("Chart 1").Chart.Axes(xlCategory)
.MinimumScale = 740.25
.MaximumScale = 746.25
End With

Cheers
Andy
Click to expand...
 
Back
Top