View Single Post
  #2  
Old April 27th, 2010, 07:08 PM posted to microsoft.public.excel.charting
Luke M[_4_]
external usenet poster
 
Posts: 451
Default Do not display Value label if value = zero

Format label, custom format:
#;;;

--
Best Regards,

Luke M
"LFNFan" wrote in message
...
Hi

I am putting together a pie chart, where values for some slices is 'zero'.
The zero slice is not visible, but the label still appears '0%'. Is there
any way of suppressing this label for the zero slice only (so the other
slices still have value labels appearing) ?

Many thanks for any help