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

PRIME MEMBER EXCLUSIVES: Find these Amazon Prime-member exclusive deals on speakers, smart TVs, smart watches and more!

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.

AMAZON TRADE-IN DISCOUNTS: Trade in & save on a new Fire TV device now!

Related

More From

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 Create and Add Multiple Columns in Google Docs

Google Docs is a convenient way to create text documents or work presentations. It offers several formatting styles that will allow you to organize...

How to Remove Hardcoded Subtitles from Video Files on VLC?

If you are looking for a way on how to remove hardcoded subtitles from a video file using VLC, you are not alone. Many...

How to Fix Not Enough Memory to Open This Page Error in Google Chrome

When opening a website on your Chrome browser, you may encounter the error message, "Not enough memory to open this page." It means that...

1 COMMENT

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected

Trending