I am trying to set custom colors to a pie chart, but the problem is that i have only 5 colors in our color palette and i want those five to reflect the top 5 customers irrespective of the parameters.
Lets say on April 30 the top 5 customers are usa,canada,UK,france and Germany , i want these colors applied to the above countries.
On May 2nd if the top 5 are usa,Uk, France,Australia,China i want those 5 colors applied to these values.
Best answer by sri75
There is an option in the chart settings to choose custom and set your color palette