how do i make pie chart ignore data labels where value is zero?

[Steppenwolf]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have a pie chart tracking the amount of time spent in a day. I have lots of possible categories and i certainly don't use them all each day, and the chart shows a bunch of overlapping labels in between slices if their value is zero. Does anyone know how to make the chart exclude these labels?

Thanks in advance!

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
Intel I have a pie chart tracking the amount of time spent in a day. I
have lots of possible categories and i certainly don't use them all each
day, and the chart shows a bunch of overlapping labels in between slices
if their value is zero. Does anyone know how to make the chart exclude
these labels?

Thanks in advance!

Usually, a value will not plot if it is #N/A. So use that instead of
Zero. If the values are the result of a formula, change your formula to
something like: =if(reference=0,na(),reference)