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

Question

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/LINE2.GIF

? · Accepted Answer

You have to use a Scatter (XY) plot. There is a variant that connects the points with lines; you just have to find it.

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

Related Questions

Trending Questions