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 object, 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 in Chart1.

Charts("Chart1").SeriesCollection(1).HasDataLabels = True