Dynamic pie chart color
 

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

Dynamic pie chart color
 

is this a double post ?

you should check the replies to your other post of this question



David Wrote:
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
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=466184