View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1
Default 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