quick question on chart axis selection in VBA

[Showard27]

Hopefully a quick question all

The following line of code is failing

Sheets("ChartByCount").FullSeriesCollection(5).AxisGroup = 2

I get a runtime error; "Method 'AxisGroup' of object 'Series' failed" Must be a syntax problem or something equally simple, but I can find the problem

Any help would be very much appreciated

 

[Domenic]

You'll need to qualify the reference to the series collection. For example, to refer to a chart named "Chart 1", try...

Sheets("ChartByCount").ChartObjects("Chart 1").Chart.FullSeriesCollection(5).AxisGroup = 2

Or, to refer to a chart by index number...

Sheets("ChartByCount").ChartObjects(1).Chart.FullSeriesCollection(5).AxisGroup = 2

Hope this helps!