Dynamic pie chart coloring

Hello,

I have a 2 cells which displays percent values ( for example 85% , 15%).
I want to display just one value in pie chart.
I create a pie chart based on these 2 values and hide one slice.

I want to change the visible slice color according to condition
but keep the hidden slice unvisible.

How can I do it ?

Thank you for your help
Daid

David,

I take it that your original question regarding hiding the 15% was answered, although I saw no response from you.

You do not state what the condition for colour might be, if it is a cell content then, without resorting to VB Code you can set the chart to be from a number of cells, that number being the colours you need +1

Set the last cell to be the 15% as =100%-sum(other cells) (as suggested in my reply to your previous post, and as demonstrated in my chart in that reply)

Set the other cells so that only one contains 85%

In the chart, in the Format Data Point for each slice set the required colour.

Originally Posted by David

Hello,

I have a 2 cells which displays percent values ( for example 85% , 15%).
I want to display just one value in pie chart.
I create a pie chart based on these 2 values and hide one slice.

I want to change the visible slice color according to condition
but keep the hidden slice unvisible.

How can I do it ?

Thank you for your help
Daid