Counting # of series on each Y-Axis

[ablattel]

Hey All,

So I have a macro that can help format series on a graph. One of the things it can do is is switch a series from the 1st Y-Axis to the 2nd and vise versa. The problem is if ALL the series go onto the 2nd axis it can mess up the X-Axis labels. Essentially, I know you can count the number of series in a chart, but I want to be able to count the number of series on each Y-Axis. This way I can figure out if the macro is about to move all of the series over to the 2nd axis and I can throw up a warning message.

Alternatively, is there a way to figure out if any given series is on which axis?

Thanks in advance you any and all help!

Cheers.

 

[Andrew Poulsom]

A Series has an AxisGroup property. It can be xlPrimary or xlSecondary.

 

[ablattel]

Thanks! I take it there is no way to have Excel count the number of series on each chart, but instead use this to do it manually?

 

[Andrew Poulsom]

Yes, you will need to loop around the SeriesCollection and test which axis each series is on.