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

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?

1

1 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

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy