Chart.SeriesCollection Method

Excel Developer Reference

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.

Syntax

expression.SeriesCollection(Index)

expression   A variable that represents a Chart object.

Parameters

Name Required/Optional Data Type Description
Index Optional Variant The name or number of the series.

Return Value
Object

Example

This example turns on data labels for series one in Chart1.

Visual Basic for Applications
  Charts("Chart1").SeriesCollection(1).HasDataLabels = True

See Also