Home |
Search |
Today's Posts |
#1
|
|||
|
|||
A pie chart shows the percentage that each value represents in the total
amount. You can include a value that's 15% of the total, and set its Area to No Fill in the pie chart. David wrote: I want to display one record as pie chart, for example 85%. How can I do it without set another cell to 15% and hide it within the chart -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#2
|
|||
|
|||
Display one cell as a pie chart
Hello,
I want to display one record as pie chart, for example 85%. How can I do it without set another cell to 15% and hide it within the chart ? Thank you David |
#3
|
|||
|
|||
David, Best I can do is as per the attached chart, where the 15% portion was hidden via Format Data Point (click within the chart). Also, C1 is 100% less B1, in case the 85% changes. Hope this helps David Wrote: Hello, I want to display one record as pie chart, for example 85%. How can I do it without set another cell to 15% and hide it within the chart ? Thank you David +-------------------------------------------------------------------+ |Filename: Book1.zip | |Download: http://www.excelforum.com/attachment.php?postid=3794 | +-------------------------------------------------------------------+ -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=466146 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
cell color index comparison | New Users to Excel | |||
large text amount in cell will not display in the cell | Excel Discussion (Misc queries) | |||
Need Workaround for Cell Display Limitation in Excel 2000 | Excel Discussion (Misc queries) | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel |