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


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question