Pie chart assigned colors to labels

[Kra]

Hi all,

Is there a way to assign specific colors to labels in Pie Chart? I have 2 labels: Banana and Apple. I would like to have pie chart slice for banana always yellow and red for apple. If there is no banana on chart, it should be only red.

 

[russonf]

have you tried assigning the cell you are counting the colour and then adding the chart?

 

[Kra]

have you tried assigning the cell you are counting the colour and then adding the chart?

You mean just to fill in color? It is not working