View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
klp klp is offline
external usenet poster
 
Posts: 13
Default suppress zeros in a pivot chart

Is there anyway to suppress the zeros in a pivot chart? My pivot table shows
activities for many different queues, and sometimes a particular queue won't
have a value for an activity that another queue has. When i chart just this
queue, the activity shows up as 0%. I don't want to delete the label, because
then when i change to another queue that DID have that activity, the value
won't show up.

Any thoughts?
thanks!
~klp