So you want it to do something like this?
I just selected all three columns of data and created a scatterplot, then right clicked on a data point that i wanted to be a line and hit "Change Series Chart Type" and changed it to the XY graph with a line.