Multiple SeriesCollection Selection

[Guest]

I have this piece of code:

ActiveChart.SeriesCollection(1).DataLabels.Select

I would like to know if it is possible to change the line so it would select
multiple SeriesCollections at once. Is there something like a
SeriesCollection(all) or (*) or...

Thanks

 

[Jon Peltier]

You can't do it as you want, in a single statement. But it is easy enough to write a
loop:

Dim Srs as Series

For Each Srs In ActiveChart.SeriesCollection
Srs.DataLabels.Font.ColorIndex = 3
Next Srs

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______