If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
0's appearing in chart, even when cell is empty
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? |
#2
|
|||
|
|||
0's appearing in chart, even when cell is empty
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 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Alex" wrote in message news 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? |
Thread Tools | |
Display Modes | |
|
|