View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Setts Setts is offline
external usenet poster
 
Posts: 7
Default 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