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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top