HomeHow ToHow to Apply & Use Chart Filters in Microsoft Excel for Mac...

How to Apply & Use Chart Filters in Microsoft Excel for Mac or PC

Author

Date

RECOMMENDED: Download this tool to help you safely fix common Windows errors & automatically optimize system performance

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.

How-to-Recover-Restore-an-Deleted-Unsaved-Excel-File
Photo credit: rawpixel/Freepik

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.

STILL HAVING ISSUES? Try this tool to troubleshoot Windows errors and safely optimize system performance

Related

More From

How to Choose a Gaming Mouse for All Grip Styles

There are a lot of things that are involved in gaming, from keyboards, gaming mice, processors, monitors, gaming graphics cards, and many more things,...

How to Fix Escape (ESC) Key on WoW Not Working Issue

In the world of online gaming, almost all players are familiar with World of Warcraft (WoW) on PC. For many years, it has become...

How to Use Bing Visual Search on Windows Search Bar

There are so many questions we have in our minds and these sometimes pop up in the middle of a task. Looking for answers...

Turn Off and Stop Netflix from Asking “Are You Still Watching?”

We all love to binge-watch a series if we are glued to its plot and characters. Streaming services such as Netflix make it possible...

1 COMMENT

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected

Trending