FullSeriesCollection Object (Excel)

Office 2013

Represents the full set of Series Object (Excel) objects in a chart.

Version Added: Excel 2013

The FullSeriesCollection Object (Excel) object enables you to get a filtered out Series Object (Excel) object and filter it back in. It also enables you to iterate over the full set of Series object, filtered out or visible, programmatically. By having the existing SeriesCollection Object (Excel) 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 (Excel) object in the second chart.

MsgBox Chart(1).FullSeriesCollection.Item(2).Name
Show:
© 2014 Microsoft