method of axes of object failed

G

Guest

I am trying to syncronize two charts, but I am getting a "Run-time error
1004, method of axes of object failed" error.

I am getting this right out of a book to help me with vba, but this one
isn't working.

This is what I have:
Sub SynchronizeCharts()
Dim myWest As Chart
Dim myEast As Chart

Set myWest = ActiveSheet.ChartObjects("West").Chart
Set myEast = ActiveSheet.ChartObjects("East").Chart

myWest.Axes(x1value).MaximumScaleIsAuto = True
The line above is where I am getting the error. Can anyone tell me why?

TIA
 

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

Top