Edit

Share via

Chart.FullSeriesCollection method (Excel)

  • Article

Enables retrieving the filtered out series specified by the Index argument.

Syntax

expression.FullSeriesCollection (Index)

expression A variable that represents a Chart object.

Parameters

Name Required/Optional Data type Description
Index Optional Variant The indexed number of the filtered out Series object.

Return value

Object

Remarks

Series objects in hidden rows or columns don't appear in the current series collection unless the user has enabled the Show data in hidden rows and columns option in the Select Data dialog.

Note

You can also use the series name in quotes:

expression.FullSeriesCollection("series name in quotes")

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.