Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Dynamic bar chart, must ignore "n/a" data... | Charts and Charting in Excel | |||
dynamic end on chart | Charts and Charting in Excel | |||
how to change range for dynamic chart in excel 2000 with button? | Charts and Charting in Excel | |||
dynamic chart with scroll bar | Excel Discussion (Misc queries) |