SeriesCollection Method

Applies To

Chart object, ChartGroup object.

Description

Returns an object that represents either a single series (a Series object, Syntax 1) or a collection of all the series (a SeriesCollection collection, Syntax 2) in the chart or chart group.

Syntax 1

expression.SeriesCollection(Index)

Syntax 2

expression.SeriesCollection

expression Required. An expression that returns a Chart or ChartGroup object.

Index Optional Variant. The name or number of the series.

Example

This example turns on data labels for series one.

myChart.SeriesCollection(1).HasDataLabels = True