Pivot chart (bar graph) colors changes everytime

[santoshbhagade]

I have prepared a pivot chart (bar graph) with few slicer. However when I select any field from the slicer the colours are getting change. Is there any workaround for this?

Thanks,
Santosh

 

[NARAYANK991]

Hi ,

See if this link helps :

http://peltiertech.com/pivot-chart-formatting-changes/

I assume you have not checked this already.

Narayan

 

[santoshbhagade]

Hay thanks Narayan,

 

[Schu]

Try unselecting "Automatic" when you format the data series. Select a solid color or whatever you wish except automatic and colors should remain without any VBA.

 

[santoshbhagade]

Hi Schu,
thanks for the solution, its perfect. cheers