I'm having a bit of trouble creating a scatter plot with data in the following format. In one table I have a series of date columns with the time I reached a given progress marker each data represented in rows. In another column I have the distance between those markers. I would like to setup a scatter plot with the distance and time on the axes, additionally connecting the data points for each day.

excel.png

Ignore the fact that in this graph there are two separate tables for there and back again. I would like to do this without repeating the distance data over and over again, but wouldn't know how to do it even with that compromise.