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. 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=466428 |
All times are GMT +1. The time now is 06:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com