Edit

Share via

Series.IsFiltered property (Excel)

  • Article

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

Syntax

expression.IsFiltered

expression A variable that represents a Series object.

Remarks

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.

Property value

BOOL

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.