FullSeriesCollection object (Excel)
Represents the full set of Series objects in a chart.
Remarks
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.
Example
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
Methods
Properties
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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for