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'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?

share|improve this question

1 Answer 1

up vote 8 down vote accepted
  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
share|improve this answer

Your Answer


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.