Pivot Pie Charts - How to change colour formatting when using slicers

Hey all,

I've created several pivot pie charts. However, I need to use specific colours for each slice.

Is there a way to change the colour for each of the 3 categories so that when I alter the pivot chart using slicers, the colours remain. At the moment, if I change the colours of the chart, they will only stick for the option selected through the slicer which I altered. Any other choice will revert back to the original colours.

Thanks!!

Mike

I tried this, my colors stayed. can you upload your sample file?

Thanks Dineth. I've since figured it out Just created a secondary table to match the pivot.