FullSeriesCollection interface

Office 2013 and later

Represents the full set of Series objects in a chart.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

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 Excel from breaking existing chart solutions on charts with filtered out data.

Show: