Excel.ChartGroup.SeriesCollection.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
ChartGroup.SeriesCollection method (Excel)	vbaxl10.chm568088	vbaxl10.chm568088	Excel.ChartGroup.SeriesCollection	7da987dc-5629-1b7d-9269-cadbec2f8c46	04/20/2019	medium

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.

Syntax

expression.SeriesCollection (Index)

expression A variable that represents a ChartGroup 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 on Chart1.

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

[!includeSupport and feedback]