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 a

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

labels a
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