Pie Chart showing 0

[Keyrookie]

Hey all,

I have a pie chart that is showing a "0" for no reason. Even whe
there is data being referenced the chart will show the correc
percentage and label for all data but the "0;0%" still shows on th
chart. I've checked all my source data multiple times and can not fin
an error.

Please help!

 

[John Mansfield]

You first might want to check . . . make sure that the total equals exactly
100% (including rounding). If it does not, Excel will force the pie chart
percentages to equal exactly 100%. The forcing of the percentages could
cause the zero value to appear.

 

[John Mansfield]

Sorry - I forgot to add a link to Microsoft's Knowledge Base that helps
explain my response:

http://support.microsoft.com/kb/214033

--
John Mansfield
http://cellmatrix.net