Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 14 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
1  
Assuming the value for 12/4/2013 is an empty cell. If it's a formula that returns "", then Excel interprets the "" as text, and plots it as zero. If this is the case, have the formula return NA() instead of "". This puts the #N/A error into the cell, and the chart skips any marker for that point but connects the two points across the #N/A by a straight line. – Jon Peltier Apr 8 at 14:43

Your Answer

 
discard

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.