Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a column with some cells have 'digits' data, and other have blank or ' ' data.

How can I remove all the cell with blank or ' ' data so that when I plot a graph, it does not treat it as '0'?

Thank you.

share|improve this question
See my answer to this question. – Scott Oct 2 '12 at 20:57

Fill the blanks with #N/A. You can do a select special blanks (F5), type #N/A and Ctrl+Enter to fill your cells. This should take them out of your graph.

share|improve this answer
True blank cells in Excel are not plotted by default. "" in a cell is text, not blank, and is treated as a zero. #N/A is not plotted in line or scatter plots. – Jon Peltier Nov 27 '12 at 20:56

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.