Microsoft Excel logo on a green background

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!

Filter a Chart in Excel on Windows

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).

Click Chart Filters in Excel on Windows

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.”

Filtered chart in Excel on Windows

Advertisement

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.

Remove a Filter

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.”

Check the boxes for Select All

Your chart should then be back to its original view.

Filter a Chart in Excel on Mac

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.”

Select Filter under Sort and 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.

Filter the data in Excel on Mac

Advertisement

When you finish, click “Apply Filter” or check the box for Auto Apply to see your chart update immediately.

Filtered chart in Excel on Mac

Remove a Filter

To return your chart to its original view, simply remove the filter. Click the filter button at the top of the column you filtered by and select “Clear Filter” in the pop-up box.

Click Clear Filter

You can turn off the data filter if you like as well. Go back to the Home tab, click Sort & Filter in the ribbon, and deselect “Filter.”

Filters are not just handy for data sets, but charts as well. So remember this tip the next time you want to highlight data in a pie, column, or bar chart in Excel.

Profile Photo for Sandy Writtenhouse Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.
Read Full Bio »

The above article may contain affiliate links, which help support How-To Geek.