Skip blank cells in chart data

**mehulkar** · 01-29-2011, 04:19 PM

Hi,

I have a column of data that I want to display as a chart. However, there are some blank cells in the column. When I use a simple line chart, the chart drops the line all the way down to zero for the blank cells.

If the blank cell is B4 in column B, is it possible to make excel ignore that cell and connect B3 and B5 with a straight line?

**Cutter** · 01-29-2011, 04:26 PM

Assuming that "blank" cell is actually a "" result from a formula in that cell - change your formula to show NA() instead of "".

If that cell is actually blank you can tell Excel to ignore blank cells.

**mehulkar** · 01-29-2011, 04:31 PM

Originally Posted by Cutter

Assuming that "blank" cell is actually a "" result from a formula in that cell - change your formula to show NA() instead of "".

If that cell is actually blank you can tell Excel to ignore blank cells.

Thanks for the quick reply. How do I tell Excel to ignore blank cells?

The cells are not a result of a formula. they are data points manually entered.

**Cutter** · 01-29-2011, 04:43 PM

Right click within the chart area and then click Select Data

Then click on the Hidden and Empty Cells button

Click on Connect data points with line

Click OK, then OK again