Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .