Not showing Data points with Zero value

[Neal]

Dear experts,

I am trying to graph (pie chart) data and some of the data
points have a zero value. I do not want those to show in
pie chart. Is there any way to have a zero supression in
the pie charts? Thanks in advance.

Neal

 

[Jon Peltier]

Neal -

That narrow a wedge is probably not visible <g>. You can suppress the
labels with a custom number format. Double click the labels and click
on the Number tab. Click on Custom, and add two semicolons after the
format (General or 0.00% or whatever). This doesn't work if you're
using labels plus percentages for the data labels.

- Jon

 

[Andy Pope]

Hi Neal,

This may help,
(http://www.andypope.info/charts/piezeros.htm)

Dear experts,

I am trying to graph (pie chart) data and some of the data
points have a zero value. I do not want those to show in
pie chart. Is there any way to have a zero supression in
the pie charts? Thanks in advance.

Neal

--

Cheers
Andy

http://www.andypope.info

 

[Jon Peltier]

Andy -

That's better than the macro I was going to post that deleted the label
but kept the point in the chart. When the data changed you had to run
another macro to reset the labels (or do them manually).

- Jon