Pie Chart and Zero Value Labels
 

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

Pie Chart and Zero Value Labels
 

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

Hardip wrote:
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, Microsoft MVP - Excel
http://www.andypope.info