View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
tshad[_2_] tshad[_2_] is offline
external usenet poster
 
Posts: 12
Default Pie Chart not showing 0%

Using Excel 2003 sp3, is there a way to tell the chart not to display 0%
values?

I have various tables where the values are 0 and they are showing up on the
Pie chart as 0% (since I am telling it to display the data as percentages).
It shows a thin line and the number 0%.

Is there a way to tell it not to display the 0 values in both the legend and
the Pie chart?

Thanks,

Tom