Hide Zero Values

[Ron]

I've checked to show values and labels. The zero value
shows with no label. In some cases I have 3 or 4 zero
values, so I get a nice pie chart with a bunch of 0%
labels. Is there an option to supress showing the value
and label if the value is zero?

Thank you

 

[Andy Pope]

Hi Ron,

You could use Autofilter on your data.
Use a custom filter 'greater than' zero.

or I have an example that uses a few columns of formula and named ranges.
(http://www.andypope.info/charts/piezeros.htm)

or you could build your own data label text in adjacent cells and link
the datalabels to the cells.
you could use this addin to help link datalabels and cells.
(http://www.appspro.com/utilities/Labeler.asp )

I've checked to show values and labels. The zero value
shows with no label. In some cases I have 3 or 4 zero
values, so I get a nice pie chart with a bunch of 0%
labels. Is there an option to supress showing the value
and label if the value is zero?

Thank you

--

Cheers
Andy

http://www.andypope.info