Hi,
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.