Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.