Setting chart error bars with VBA

[MrPez]

I have a chart and I'm trying to use VBA to set the length of the error bars on one of the series.

If I manually select the chart the following line works:

ActiveChart.SeriesCollection("MySeries").ErrorBar Direction:=xlX, Include:=xlPlusValues, Type:=xlFixedValue, Amount:=1

However, I'm trying to automate it without manually selecting the chart.
I've tried modifying it to:

Sheets("MySheet").ChartObjects("MyChart").ActiveChart.SeriesCollection("MySeries").ErrorBar Direction:=xlX, Include:=xlPlusValues, Type:=xlFixedValue, Amount:=1

but it gives the error 'Object doesn't support this property or method'.

Can anyone point out where I'm going wrong?

 

[pgc01]

Hi

Sheets("MySheet").ChartObjects("MyChart").[B][COLOR=#800000]Chart[/COLOR][/B]....

 

[MrPez]

Sheets("MySheet").ChartObjects("MyChart").Chart.SeriesCollection("MySeries").ErrorBar Direction:=xlX, Include:=xlPlusValues, Type:=xlFixedValue, Amount:=1

This now gives 'Invalid Parameter'...

 

[MrPez]

All sorted
Turns out there was another chart hidden behind the first one which I wasn't aware of which was causing the problems. Other than that, pgc01 your amendment got it working. Thanks for the help.

 

[pgc01]

I'm glad you figured the problem out.