defining the x-axis and the variable in line graphs

[OliviaGW]

This seems like a really stupid problem but I don't know how to fix it!

I have a table that looks like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Year[/TD]
[TD]Megawatts[/TD]
[/TR]
[TR]
[TD]2010[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]2011[/TD]
[TD]106[/TD]
[/TR]
[TR]
[TD]2012[/TD]
[TD]174[/TD]
[/TR]
[TR]
[TD]2013[/TD]
[TD]326[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]618[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]1121[/TD]
[/TR]
</tbody>[/TABLE]

I want to make a line graph that just shows the growth in megawatts over time, with the years on the X-axis. Whenever I try and make a line graph however, it shows two lines, one with the MW and one for years. It doesn't seem to have recognised that the year column should be an axis and not a variable.

BUT, when I make a scatter plot, it puts the years in the x-axis and the megawatts as data points inside the graph, just like I want. This is great, but I want line graph!

I'm sure there's a simple answer to this, but I don't know what it is. Can you help me?

 

[mgm05267]

Hi...
Check this link

Linechart.xlsx download - 2shared

 

[OliviaGW]

Could you possibly explain in words what to do? I have to download some kind of programme onto my computer to view your link. Thanks!!