Hide labels for zeros in charts

[ebetke]

I built a pie chart with a selection dropdown list. I wnat to suppress the labels for the zero values. Any suggestions to how I can do this?

Eric

 

[jeffreybrown]

Hi Eric,

Try to format the data labels with 0;;;@

 

[ebetke]

Thanks Jeff! Worked like a dream.

 

[jeffreybrown]

Thanks for letting me know...glad it worked for you