Pie Chart Color Code

[rainstorm9]

I have a table which contains customers and their answers to 5 survey question. Their answer to these 5 questions are kept in 5 fields and coded as number 1 to 10. Now I have created a pie chart for each of these 5 questions and I want to keep the color code to be the same. So an answer of 1 should show the same color across all the pie charts.

I have tried to keep the sorting order to descending and check the box for keep persistent color, but it's not working. I know I can always use an expression to define the colors inside each of these charts. Just want to know if there is an easy way doing it or by changing the data model. Thanks!

[Kashyap_R · Accepted solution]

Hi

You can multiple if to set the color you want for different questions.

PS if you can attach the excel or QVF file it will be helpful to others to try and to get back to you.

thanks