data labels on charts

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top