dynamic Pie chart color slices

[tovabc]

Hi,
I'm dealing with dynamic Pie chart showing the wage components the employee recieved during 2016, and the issue is Pie chart color slices.

we don't want to have slices with zero values, and that's is the reason I put filter for.

Some of our employees don't recieve Bonus, and we don't want the employees to recieve a Pie with Bonus slice = 0.

But the problem is with slice color, as you see, the slice color of the Bonus is RED, and after I filtered the data, the Benefits slice recieve the RED color, How can I change it so each slice color is depened on the slice name and not position?

Thanks in advance,
Tova

[cbatrody]

Hi,

Try the following:

Uncheck "Vary colors by slice" option first
Select Individual slices 1 at a time
Color them individually (the preferred background colors for each slice)
Now the manually set colors won't change when the number of slices increase/decrease

[tovabc]

Excellent solution!!!!

[tovabc]

Excellent solution!!!!

[cbatrody]

Thank you

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.