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

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.

Related

1 COMMENT

LEAVE A REPLY

Please enter your comment!
Please enter your name here

More From

How to Clear Disney Plus App Cache and Data on Any Device

We all heard of clearing the cache when issues arrive on our devices. Cache memory is crucial in the overall process as it improves...

How to Compress & Reduce Large Microsoft Excel Spreadsheet File Size

Working with Microsoft Excel can make your data presentation appear more organized and professional. However, you may sometimes come up with a large Excel...

Hard Reset Panasonic Smart TV or Restore to Factory Settings

When watching movies or shows on your smart TV, there are times when you encounter errors. There are no pictures on the screen, or...

How to Change Reddit Username

There are times when we want to change our username in a website or forum and it happens for different reasons. It is not...

Recent Articles

Stay Connected

Trending