Re: data labels on charts

If the label says "#N/A" in the chart, and the column has an apparent value
of zero, then any text value will do the same.

Assuming the source data is filled with formulas, change the formulas to
something like:

=IF(ISNA(formula),"#N/D!",formula)

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/>
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"God Itself" <(E-Mail Removed)> wrote in message
news:gsjv7i$shq$(E-Mail Removed)...
Hi,

how can i change #N/D! label into "n/a" or "" with some VBA code.

i have column chart with series which data end before end of period.

i.e values are:

=1.3
=1.4
=1.3
=1.2
=NA()
=NA()

labels are:
1.3 (non-zero column)
1.4 (non-zero column)
1.3 (non-zero column)
1.2 (non-zero column)
#N/D! (zero value column)
#N/D! (zero value column)

how can i change ONLY labels with #N/D! into "n/a" or ""

is there possibility of change without loosing functionality because
sometimes series are fully with data.
and how i can change labelling only for particulars charts?

regards