Formula to yield a blank that won't be graphed as zero

[steve case]

My data looks like this:

DATE |  DATA | Formula
1998 |  7112 | =IF(B2=9999,"",B2)
1999 |  9999 | 
2000 |  7059 | 7059

If I copy the formula in C2 on down and graph it out, Excel interprets "" as zero, and not as a blank cell.

Is there a way to have a formula produce a result that will be interpreted as Blank?

Background: Lots of data bases use a string of nines (9999) to represent missing data.

 

[steve case]

Sorted, as in, "Do you now have the behavior you want?"

Never heard sorted used that way. Out of sorts maybe.

Well anyway, I'm done with this topic, you gave me the
answer "Excel doesn't regard the cells that have formulas
that return blanks as empty cells." So I will figure out
the next best way to get what I want.

Thanks for your help, I appreciate it.

 

[shg]

You're welcome.