Graphs and charts give you an easy way to display data at a glance. But what if you want to focus on a particular part of your chart? By applying a filter to an Excel chart, you can emphasize specific data.
With Microsoft Excel on Windows, you can quickly filter your chart data using a handy button. Excel on Mac doesn’t currently offer this feature, but you can still apply a filter to the data which updates the chart. Let’s look at both!
You can certainly use Excel’s data filter on the Home tab. But Microsoft makes applying a filter to a chart a bit simpler on Windows.
Select the chart and you’ll see buttons display to the right. Click the Chart Filters button (funnel icon).
When the filter box opens, select the Values tab at the top. You can then expand and filter by Series, Categories, or both. Simply check the options you want to view on the chart, then click “Apply.”
Note that some chart types don’t offer the Chart Filters option such as Pareto, Histogram, and Waterfall charts. You can still filter the chart by applying a filter to the data instead. Follow the steps below for filtering a chart on Mac as the steps are the same in Excel on Windows.
When you finish using the Chart Filters, click that button once more to open the filter box. Check the boxes for Select All in Series or Categories, depending on the filter you used. Then, click “Apply.”
Your chart should then be back to its original view.
Since there isn’t a Chart Filters button next to a chart you create in Excel on Mac, you’ll need to use the data filter on the Home tab.
RELATED: How to Create and Customize a Funnel Chart in Microsoft Excel
Select the data for your chart, not the chart itself. Go to the Home tab, click the Sort & Filter drop-down arrow in the ribbon, and choose “Filter.”
Click the arrow at the top of the column for the chart data you want to filter. Use the Filter section of the pop-up box to filter by color, condition, or value.