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

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

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

Try:
=NA()
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Setts" wrote in message
...
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