I have created a report in Excel for my company that has some pivot charts on one sheet. The pivot tables underlying these charts have report filters that work perfectly on a pc. However a colleague who is using a mac, cannot see the report filters in the chart and even when a new filter is selected in the pivot tables themselves, the chart does not update. Has anyone experienced this?
According to http://www.annielytics.com/blog/excel-tips/excel-bug-in-pivot-charts-on-the-mac/ there is no fix for this, but I hope there is some way to make use of this basic and important functionality in some way.
- Edited by Mustikah 16 hours 21 minutes ago