Creating a more organized presentation of your data is possible thanks to Microsoft Excel. You can create charts and graphs to display all the information in one place. If you want to edit the values on each chart on your spreadsheet, you can use the Chart Filters in Microsoft Excel.
While you can access and use the Microsoft Excel app on Mac and PC computers, some functions may not be the same. How you do filtering your chart data on Windows 10/11 PC is not the same on your MacBook or iMac computer. Windows has the Chart Filters button while Mac will make you work around a bit.
Using Microsoft Excel Chart Filters on Windows 10/11 PC
To use the chart filters, you need to select the chart on your MS Excel worksheet. You can select the chart by going to the Insert tab on the Home tab. Choose the chart that you want to use to add it to your worksheet.
If you already have the chart in the worksheet, you can simply click on it for the Chart Filters button to appear.
- Click the Chart Filters button next to your chart.
- You will see the Values and Names section.
- Check and uncheck the boxes next to the data you want to see and hide on your chart.
- Once done, click Apply.
- To remove the filter applied previously, click the Chart Filters button.
- On the Series and Categories, check the Select All boxes.
- Click Apply. It will show the original chart.
TODAY’S DEALS: Check out these limited-time offers on the latest Windows 11 laptops at Amazon & Walmart!
How to Apply Chart Filters in Microsoft Excel Worksheets on a Mac Computer
As mentioned above, there is no Chart Filters button function when using Microsoft Excel on a macOS computer device. However, there are ways you can still filter Microsoft Excel data on your charts.
- Select the chart that you want to filter.
- Go to the Home tab.
- Select Sort & Filter.
- Choose Filter.
- Click the arrow next to the data that you want to filter.
- A pop-up box will appear.
- Set your filter requirements.
- Once done, click Apply Filter.
- If you want to revert to the original chart, click Clear Filter.
TODAY’S DEALS: Limited-time deals on the latest Mac computer models at Amazon & Walmart!
If you use Word or PowerPoint, you can filter the charts by sending them to Microsoft Excel.
- Select the chart that you want to filter.
- Go to the Chart Design tab.
- Choose Edit Data in Excel.
- Your Microsoft Excel will open.
- Once there, you can filter the chart based on the method above.
What do you think of the Microsoft Excel Chart Filters feature? Is it helpful for you? We would love to know what you think, so please drop your answers below.
On the Mac, Sort & Filter is not available when a chart is selected.