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