Costas
Member
Hi Chandoo,
I've created a pivot chart with many slicers around it. I've hidden the pivot table so users can focus on the chart and slicers.
To remove filters, I either need to unhide, select the pivot table and click on clear all or remove individual filters from each slicer.
If I don't click on the pivot table then the clear all option is disabled.
Is there another way round this without having to create a macro?
Thanks
Costas
I've created a pivot chart with many slicers around it. I've hidden the pivot table so users can focus on the chart and slicers.
To remove filters, I either need to unhide, select the pivot table and click on clear all or remove individual filters from each slicer.
If I don't click on the pivot table then the clear all option is disabled.
Is there another way round this without having to create a macro?
Thanks
Costas