Connect the Line for a Chart in Excel and Skip Blanks

How to prevent a line chart from having a blank spot or also dropping to zero when there is a blank cell or a zero value that should be blank cell.

Here is the problem:

Connect the Line for a Line Chart

1. Click the desired chart and then go to the Design tab that should appear and click Select Data.
   
2. In the window that opens, click Hidden and Empty Cells
   
   
3. In the smaller window that opens click Connect data points with line and hit OK.
   
4. That's it!
   

Zeros that Should be Blanks

If you have zeros in your data that you are using to represent a blank value, the chart will not understand this and will, instead, represent it as zero in the chart.

As such, DO NOT use a zero to denote emptiness in a set of data that you will put into a chart or it won't look right.

Notes

Download the accompanying spreadsheet to see this in Excel.