FullSeriesCollection object (Excel)

Represents the full set of Series objects in a chart.


The FullSeriesCollection object enables you to get a filtered out Series object and filter it back in. It also enables you to iterate over the full set of Series objects, filtered out or visible, programmatically.

By having the existing SeriesCollection object contain only the visible series, you can programmatically perform operations on only the visible series. It also prevents Microsoft Excel from breaking existing chart solutions on charts with filtered out data.


The following example displays a message box with the name of the second Series object in the second chart.

MsgBox Chart(1).FullSeriesCollection.Item(2).Name



See also

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.