0's appearing in chart, even when cell is empty

A

Alex

I have imput the following formula into cell B5 =IF('[sUMMARY
Summer.xls]Ethnic Origin (Platinum)'!$D$4<>"",'[sUMMARY Summer.xls]Ethnic
Origin (Platinum)'!$D$4,NA())

What I wanted it to do was for my chart to ignore anything in this
particular cell, and not show any value, but when I do this the value on the
chart is #N/A, as opposed to 0 when I simply had the last part of the formula
above "" as opposed to NA().

What is it that I am doing wrong?
 
B

Bernard Liengme

Not clear what is meant by "the value on the chart is #N/A". If this cell is
one of your y-values (data values), it is used to position the chart point;
not display a value.
Excel ignores NA as a y-value.
Tell use exactly what ranges you are plotting
If this cell is part of your x-values then you must make an XY chart not a
line chart to have Excel ignore it.
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

Similar Threads

#N/A plotted as 0 on line chart 0
Impossible? Not plotting NA()s 2
Plotting NA() or #N/A data points 1
Don't plot non-numeric cells 2
Empty strings appear as zeros 5
Custom Formatting a Chart Data Label 1
OTHER options for chart not plotting null ("") or zero values 2
Line chart to zero 2

Top