Series.IsFiltered (Excel)

This setting controls whether the series has been filtered out from the chart. The default value is False.

When a user filters out a series, the series IsFiltered property switches to True, and the series is transferred out of its parent SeriesCollection. However, that series still remains in its parent FullSeriesCollection. When a user filters the series back in, it is inserted back in its original place in the SeriesCollection.


ActiveChart.FullSeriesCollection(1).IsFiltered = True