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

You have
x1value
but the constant is

xlvalue

the difference is xL vice x(one)

--
Regards,
Tom Ogilvy

"Papa Jonah" wrote in message
...
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

thank you very much!

"Tom Ogilvy" wrote:

You have
x1value
but the constant is

xlvalue

the difference is xL vice x(one)

--
Regards,
Tom Ogilvy

"Papa Jonah" wrote in message
...
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