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

chartsmicrosoft excel

I'm charting daily values using a line chart. On some dates, I don't have any data. I would like the chart to connect the data points for which I have data across any gap in data.

So for example if my data is:

12/1/2013  1
12/2/2013  2
12/3/2013  2
12/4/2013  
12/5/2013  1

I would like to see the 12/3 data point ("2") connect to the 12/5 data point ("1"). How do I do that?

Best Answer

  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
Related Question