Setting error bars in VBA

[MrPez]

Hopefully this is a simple one...
I'm trying to set the errorbar for a chart series with VBA and I'd like to do it without actually selecting the series.
Can anyone tell me why this works:

Sheets("DAPReport").ChartObjects("MedianDAP").Activate
ActiveChart.SeriesCollection(2).ErrorBar Direction:=xlX, Include:=xlPlusValues, Type:=xlFixedValue, Amount:=45

but this doesn't:

Sheets("DAPReport").ChartObjects("MedianDAP")SeriesCollection(2).ErrorBar Direction:=xlX, Include:=xlPlusValues, Type:=xlFixedValue, Amount:=45

 

[RoryA]

You're missing a Chart object - use:

Sheets("DAPReport").ChartObjects("MedianDAP").Chart.SeriesCollection(2).ErrorBar Direction:=xlX, Include:=xlPlusValues, Type:=xlFixedValue, Amount:=45

 

[MrPez]

Thanks Rory!