Change Pie Chart segment color based on value in source data

[Doug]

I am creating a training matrix which shows current status of training
progress. I want the pie chart to always display three equal segments. I want
each segment color to change based on the data input in the source data.
Hopefully this is an adequate definition of what I am trying to do?

 

[Andy Pope]

Hi,

Assuming you have 3 possible colours for each segment you need to create
a pie chart based on 9 cells. The content of the cells is determined by
formula and will either display a 1 or 0.

Training data in range B2:B4 with values 1, 2 or 3 to indicate level.
Formula in cells F1:F9

F1: =IF(B2=1,1,0)
F2: =IF(B2=2,1,0)
F3: =IF(B2=3,1,0)
F4: =IF(B3=1,1,0)
F5: =IF(B3=2,1,0)
F6: =IF(B3=3,1,0)
F7: =IF(B4=1,1,0)
F8: =IF(B4=2,1,0)
F9: =IF(B4=3,1,0)

So create your pie chart on the range F1:F9. The pie should only display
3 slices. Use the legend keys to format the colours of each of the
segments. Points (1,4,7) , (2,5,8) and (3,6,9) should be formatted in
the appropriate progress level.

If you have move than 3 levels of progress you simply need to increase
the number of formula based cells.

Cheers
Andy

 

[Doug]

Andy,
Your solution works perfectly. Thank you for your help!!