How to have Excel chart connect data points when no value?

Solution 1:

  1. Go to the Select Data dialoge box for the chart
  2. click Hidden and Empty Cells
  3. Change Show empty cells as to Connect data points with line