SeriesCollection Method

Applies To

Chart Object, ChartGroup Object.

Description

Accessor. Returns an object that represents 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

object.SeriesCollection(index)

Syntax 2

object.SeriesCollection

object

Required. The Chart or ChartGroup object.

index

Required for Syntax 1. 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