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

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



Bernard Liengme

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

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

Label utilities
Rob Bovey's Chart Labeller,
John Walkenbach's Chart Tools,
Tushar's Hover Chart Label utility:

best wishes

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