View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
ck13 ck13 is offline
external usenet poster
 
Posts: 44
Default Pie charts - 0 values

Hi,

I have selected data labels for my pie charts containing value and
percentage. However, there are 0 values in the chart and I do not want to
show them. I have tried 0%;;;; but it only hide those values in percentage
while the value data labels are still visible. And when i use 0;;;; it hides
the value data labels but the percentage labels are shown. Is there any way
to hide both set of data labels if it is 0?

thanks