I have a pie chart that I am using to represent 8 different workstreams all with a RAG status.
In column C there is the pie chart series name and in column D there is the RAG status name (IE: Red, Amber, Green etc)
I have set these cells to conditionally format based on their value of Red, Amber, Green etc.
The pie chart doesn't need any numerical values so I have put in 12.5 (100/8 items) to make up equal shares of the pie.
How can I colour each area based on the conditional formatting of the corresponding cell?
Thanks in advance! :D