PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Pie Chart showing 0
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Pie Chart showing 0
![]() |
Pie Chart showing 0 |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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! -- Keyrookie |
|
|
|
#2 |
|
Guest
Posts: n/a
|
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 http://cellmatrix.net "Keyrookie" wrote: > > Hey all, > > I have a pie chart that is showing a "0" for no reason. Even when > there is data being referenced the chart will show the correct > percentage and label for all data but the "0;0%" still shows on the > chart. I've checked all my source data multiple times and can not find > an error. > > Please help!! > > > > > -- > Keyrookie > |
|
|
|
#3 |
|
Guest
Posts: n/a
|
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 "John Mansfield" wrote: > 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 > http://cellmatrix.net > > > > > > "Keyrookie" wrote: > > > > > Hey all, > > > > I have a pie chart that is showing a "0" for no reason. Even when > > there is data being referenced the chart will show the correct > > percentage and label for all data but the "0;0%" still shows on the > > chart. I've checked all my source data multiple times and can not find > > an error. > > > > Please help!! > > > > > > > > > > -- > > Keyrookie > > |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

