To apply chart filters to excel chart on mac

Copper Contributor

I have created a column chart that requires a filter. The direction is to click on the chart filters button to display the chart filters gallery. The chart filters gallery is supposed to fill a series in which I would be able to remove the check on the two boxes that will apply the filter.

 

The problem is the filter icon is NOT highlighted and am unable to click on the chart filters button to access the gallery. I have tried numerous ways and beginning to think this function is not available through mac and is there another way to apply the filters?

Thanks for any suggestions

0 Replies