Auto-exclusion of data labels for zero values

[Max]

Hi guys,

xl97 question.

Is there a way to have data labels enabled** for all points plotted
but with the labels automatically *excluded* for any zero values ?
The exclusion is desired for aesthetic reasons.

**e.g.: via Data Labels > Show value in say, Format Data Series dialog

I find that these "zero" values showing on say, a column chart, have to be
individually selected and removed on each series in a chart, a pretty
tedious task.

The values plotted are derived through formula and there would always be
a couple of points here and there evaluating to zero values from
time-to-time.

I've tried a couple of google searches for past queries / suggestions on
this issue
but was not successful.

Thanks.

 

[Frank Kabel]

Hi
have a look at the following example (for pie charts)
http://andypope.info/charts/piezeros.htm

 

[Max]

Thanks for the lead, Frank!
[and thanks to Andy, too]
Yes, the example given does help.