I need to create a pie chart to display the total number of projects and their (Traffic-light - Red, Amber, Green) status.
How do I set the colour of a pie chart section so when the status is Green the section is colour is Green.
I have used the Palettes Editor to create a new palette named RAG_Status with the three colours I need (Red, Amber, Green), but I don’t know how the configure my pie chart to make sure status red is coloured red etc…
When I use the Wizard the colours are incorrect for each RAG status.
Any help and advice would be welcome.
Thank you in advance.
Regards
David