I have a pie chart which is based on the sales of my top 5 products each
quarter.
If I have a total of 20 products, I want to assign a different colour to
each product. This colour remains the same for this product always whether it
appears in my top 5 list or not.
How do I get my pie chart segments to always be the same correct colour each
quarter ?