Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple SeriesCollection Selection
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple SeriesCollection Selection
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/ _______ Sunryzz wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SeriesCollection question | Charts and Charting in Excel | |||
SeriesCollection | Excel Programming | |||
VBA- SeriesCollection(1).Value error | Excel Programming | |||
VBA- SeriesCollection | Excel Programming | |||
calliing seriescollection by name | Excel Programming |