Have a chart line completely disappear for a Series...

[Setts]

I would like during certain situations to have a Chart line (Series)
completely disappear rather than show along the zero line. Wen I clear a
value with the delete key that cell does not show on the chart. What
character do I move to a cell to have that occur during the operation of a
spreadsheet. With the IF function I have moved in a null ("") and that
doesn't work. I have tried a blanks (" ") and that doesn't work. If I use
the delete key from the keyboard that does work. How to I set a cell to that
"delete key" value? Thanks

 

[Ragdyer]

Try:
=NA()