Thread: Pie Chart and Zero Value Labels
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default 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
Reply With QuoteReply With Quote