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.