As I mention in my post on creating pivot charts, you can’t create pivot charts in Excel for the Mac. It’s, hands down, my greatest aggravation with Excel. Bar none. However, Excel for the Mac has an additional bug that renders any pivot chart created on a PC that includes a report filter utterly useless. You can see the options in the drop-down filter and even select them. In fact, the pivot table (that’s created with every pivot chart) updates. However, your pivot chart will not update. I demonstrate this disappointing failure in this short demo.
Excel Insert Slicer Not Working. Different Ways to Filter an Excel Slicer. Excel Slicers are the best thing since sliced bread! They are a new feature from Excel 2010 onward and Mac for Excel 2016 and are visual buttons that shows you what items have been filtered or selected in a Pivot Table. Excel Slicer was first introduced in Pivot Tables in Excel 2010 for Windows and Excel 2016 for Mac. Pivot Table Slicers are a visual filter in the form of an interactive button. There are several cool things that you can do with Pivot Table Slicer, like customize them, filter them, connect them to multiple Pivot Tables plus much more!
Test For Yourself
Don’t believe me, Excel for Mac users? Go ahead and test it for yourself with the pivot chart in this Excel file.
Learn More
![Excel Excel](https://www.techrepublic.com/a/hub/i/r/2017/12/20/f47e3443-5003-4e3a-8efb-6db6d025c52b/resize/1200x/a7447cbc0c3bcb359f6c279d95966f2f/excelcustomizeslicersa.jpg)
![Mac Mac](https://www.myexcelonline.com/wp-content/uploads/2018/07/Slicer-Connection-Greyed-Out-07.jpg)
Slicers Not Working In Excel For Mac 2019
If you want to learn more about data visualizations that don’t suck, check out my Annielytics Dashboard Course offerings.
Slicers Not Working In Excel For Mac Download
Image from troll.me.