G
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
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