PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Pie Chart showing 0

Reply

Pie Chart showing 0

 
Thread Tools Rate Thread
Old 14-11-2007, 02:39 PM   #1
Keyrookie
Guest
 
Posts: n/a
Default Pie Chart showing 0



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
  Reply With Quote
Old 14-11-2007, 10:00 PM   #2
=?Utf-8?B?Sm9obiBNYW5zZmllbGQ=?=
Guest
 
Posts: n/a
Default RE: Pie Chart showing 0

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
>

  Reply With Quote
Old 15-11-2007, 01:06 PM   #3
=?Utf-8?B?Sm9obiBNYW5zZmllbGQ=?=
Guest
 
Posts: n/a
Default RE: Pie Chart showing 0

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
> >

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

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 On
HTML code is Off