data labels on charts

[God Itself]

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

 

[Jon Peltier]

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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______


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