How do you make an XY line plot in Microsoft Excel 2010?

So I need to make a XY line plot in excel but It can only create a scatter plot without any lines connecting the points. Whenever I click line plot, it creates this weird graph with two lines, one for each column of data, but that isn't what I want. I want my first column to be my x axis and my second column to be my Y axis.

Here's a picture of what it should look like:

http://mste.illinois.edu/courses/ci330ms/youtsey/L...