Pie Chart and Zero Value Labels

[Hardip]

Morning All

Is there a feature to remove all the zero value labours in a pie chart. I
have 8 categories and 5 have a 0 value so it looks very messy. I can't find
the feature but I'm sure it must exist.

Thanks in advance to all who reply.

Regards, H

 

[Andy Pope]

Hi,

You could use autofilter to hide the rows of those with a zero value.
Or formula as described here,
http://www.andypope.info/charts/piezeros.htm

Cheers
Andy