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

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?
 
A

Andy Pope

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
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

x-axis scale changes 3
Using a 'Name' to Update Chart Titles & "Y" Axis Scale 2
automatic scale a chart 1
Y axis scale macro 5
Auto Update of Y axis Max, Min and Scale 1
X-Axis Scale Options Missing 4
build chart template; then add series one by one 2
Change default axis category labels 1

Top