A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Pie charts - 0 values



 
 
Thread Tools Display Modes
  #1  
Old March 19th, 2010, 03:53 AM posted to microsoft.public.excel.charting
ck13
external usenet poster
 
Posts: 44
Default Pie charts - 0 values

Hi,

I have selected data labels for my pie charts containing value and
percentage. However, there are 0 values in the chart and I do not want to
show them. I have tried 0%;;;; but it only hide those values in percentage
while the value data labels are still visible. And when i use 0;;;; it hides
the value data labels but the percentage labels are shown. Is there any way
to hide both set of data labels if it is 0?

thanks


  #2  
Old March 19th, 2010, 12:30 PM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
 
Posts: 516
Default Pie charts - 0 values

I am not a great fan of pie charts so I have minimal experience with them,
but as an experiment I made a chart with this data
A 3
B #N/A (formula =NA())
C 6
D 5
The B point did not appear on the chart
So the advice seem to be the same for pie charts as fro all other: replace
the zero (or empty cell) by =NA()
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"ck13" wrote in message
...
Hi,

I have selected data labels for my pie charts containing value and
percentage. However, there are 0 values in the chart and I do not want to
show them. I have tried 0%;;;; but it only hide those values in percentage
while the value data labels are still visible. And when i use 0;;;; it
hides
the value data labels but the percentage labels are shown. Is there any
way
to hide both set of data labels if it is 0?

thanks


  #3  
Old March 19th, 2010, 06:14 PM posted to microsoft.public.excel.charting
Luke M[_4_]
external usenet poster
 
Posts: 451
Default Pie charts - 0 values

Change your custom formatting to allow text to be shown
0;;;@

--
Best Regards,

Luke M
"ck13" wrote in message
...
Hi,

I have selected data labels for my pie charts containing value and
percentage. However, there are 0 values in the chart and I do not want to
show them. I have tried 0%;;;; but it only hide those values in percentage
while the value data labels are still visible. And when i use 0;;;; it
hides
the value data labels but the percentage labels are shown. Is there any
way
to hide both set of data labels if it is 0?

thanks




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.