Dynamic pie chart coloring

[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

 

[Bryan Hessey]

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.