Pie chart colours based on conditional formatting of cells

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

 

Question Info


Last updated November 24, 2019 Views 10,898 Applies to:
Answer
Answer

Hello,

a pie chart cannot be manipulated with the techniques in the link Elemental posted. 

For a pie chart, it's either "in" or "out". If the value is greater than 0, it will show, otherwise it won't. 

Conditional formatting using different cells is not an option with pie charts. 

You will need to use VBA to align the slice colors with the data cells.

Or use another chart type. A stacked horizontal chart could deliver like this: 

The chart is based on the values in F2 to H13. The formula starts in F2 with

=IF($D2=F$1,12.5,0)

copy across and down. 

Such a scenario cannot be build with a pie chart, because it cannot handle multiple columns in the data range. 

___________________
cheers, teylyn
 
Community Moderator
www.teylyn.com

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.