ChartGroup.SeriesCollection method (Excel)
Returns an object that represents either a single series (a Series object) or a collection of all the series (a SeriesCollection collection) in the chart or chart group.
expression.SeriesCollection (Index)
expression A variable that represents a ChartGroup object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Index | Optional | Variant | The name or number of the series. |
Object
This example turns on data labels for series one on Chart1.
Charts("Chart1").SeriesCollection(1).HasDataLabels = True
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.