Windows & Other OS

How to apply a filter to a chart in Microsoft Excel

Charts and tables 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 with one convenient button. Excel on Mac does not currently offer this feature, but you can still apply a filter to the data which updates the graph. Let’s see 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 graph a bit simpler in Windows.

Select the graph and you will see the buttons shown on 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. Just check the options you want to see on the chart, then click “Apply.”

RELATED:   Why the iPad Mini 2021 is one of Apple's best tablets so far

Filtered chart in Excel on Windows

Note that some chart types do not offer the Chart Filters option, such as Pareto , Histogram Y Waterfall . Instead, you can filter the chart by applying a filter to the data. Follow the steps below to filter a chart on Mac as the steps are the same in Excel on Windows.

Remove a filter

When you’re done using the chart filters, click that button one more time 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 Select All boxes

Your graph should return to its original view.

Filter a chart in Excel on Mac

Since there is no Chart Filters button next to a chart you create in Excel On Mac, you will need to use the data filter on the Home tab.

Select the data for your chart, not the chart itself. Go to the Home tab, click the Sort & Filter drop-down arrow on the ribbon and select “Filter.”

RELATED:   How to delete a Tinder account

Select Filter under Sort & Filter

Click the arrow at the top of the column for the chart data that 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

When you’re done, click “Apply Filter” or check the Automatic Apply box 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 through and select “Clear filter” from the pop-up box.

Click Clear Filter

You can also disable the data filter if you want. Go back to the Home tab, click Sort & Filter on the ribbon, and deselect “Filter.”

Filters are not only useful for data sets, but also for charts. So remember this tip the next time you want to highlight data in a graphic circular, column or bars in Excel .

Related posts

Leave a Comment