Excel Tutorial: Filter Data in Excel Charts
How to filter data in Excel Charts
When you filter data in a chart, you can hide the display of the data series rather than remove it outright. Follow these steps to filter data in Excel charts:
- Click the Monthly Sales chart to select it.
- Click the Chart Filters button.
- Click the check box adjacent to Erica to remove her data from the chart, and then click Apply. Erica’s data no longer appears in the chart.
- Click the Chart Filters button again to close the tab.