Custom Formatting a Chart Data Label
 

I want to create a chart which will display a zero value on the data label
where there is in fact a zero value, and show N/A on the data label where it
didn't apply. The formula I am using in the spreadsheet uses a nested formula
to make this determination:
=IF(AND(B22+C220,C220),B22/C22,NA())
Presently, it works but displays the #N/A on the chart where I would prefer
it simply displayed as N/A. Can I do this with a custom format on the data
label??

Thanks so much! I don't know how you all do it but your amazing!


--
If you can read this, thank a Teacher...
If your reading it in English, thank a Veteran!

Custom Formatting a Chart Data Label
 

If your formula is being used for both the y-values AND the label, then you
will have to live with #N/A
If you are using a chart label utility (see below) then you could use this
for the label formula
=IF(AND(B22+C220,C220),B22/C22,"N/A")

Also it seems to me (after a big lunch and two glasses of wine) that you
could begin the formula
with =IF(B22*C220,
unless you are avoiding the case when both B22 and C22 are negative.

Label utilities
Rob Bovey's Chart Labeller, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com
Tushar's Hover Chart Label utility:
http://tushar-mehta.com/excel/softwa...bel/index.html

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Telobamipada" wrote in message
...
I want to create a chart which will display a zero value on the data label
where there is in fact a zero value, and show N/A on the data label where
it
didn't apply. The formula I am using in the spreadsheet uses a nested
formula
to make this determination:
=IF(AND(B22+C220,C220),B22/C22,NA())
Presently, it works but displays the #N/A on the chart where I would
prefer
it simply displayed as N/A. Can I do this with a custom format on the data
label??

Thanks so much! I don't know how you all do it but your amazing!


--
If you can read this, thank a Teacher...
If your reading it in English, thank a Veteran!