ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Series 1 Point "0" Data Label (https://www.excelbanter.com/charts-charting-excel/165999-series-1-point-0-data-label.html)

Keyrookie

Series 1 Point "0" Data Label
 
Hello again,

This is what Excel shows when I point to the "0"

Series 1 Point "0" Data Label

How do I get rid of this label??


Thanks again.

John Mansfield

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


John Mansfield

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



All times are GMT +1. The time now is 03:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com