Muokkaa

Jaa


SeriesCollection method (Excel Graph)

Returns an object that represents either a single series or a collection of all the series in the chart or chart group.

Syntax

expression.SeriesCollection (Index)

expression Required. An expression that returns the SeriesCollection collection.

Parameters

Name Required/Optional Data type Description
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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.