Line Graph Issues

[tbeigi]

I am using the following table of data to create a line graph:

[TABLE="width: 197"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Year[/TD]
[TD]FSR Redeeming Operators[/TD]
[/TR]
[TR]
[TD]2006[/TD]
[TD]1,203[/TD]
[/TR]
[TR]
[TD]2007[/TD]
[TD]8,839[/TD]
[/TR]
[TR]
[TD]2008[/TD]
[TD]14,984[/TD]
[/TR]
[TR]
[TD]2009[/TD]
[TD]20,229[/TD]
[/TR]
[TR]
[TD]2010[/TD]
[TD]30,216[/TD]
[/TR]
[TR]
[TD]2011[/TD]
[TD]33,761[/TD]
[/TR]
[TR]
[TD]2012[/TD]
[TD]34,448[/TD]
[/TR]
[TR]
[TD]2013[/TD]
[TD]34,846[/TD]
[/TR]
</tbody>[/TABLE]

Unfortunately, when I select this data and try to insert the line graph, it gives me a strange chart that does NOT show me the year on the X-axis. Instead, it lists numbers (1,2,3...8). Everything is listed as a Number and I tried playing around with the Axis Options, but to no avail. Any help would be greatly appreciated!

 

[Momentman]

1. With the chart selected, Go to the Design tab and Click Select data
2. To the right, you will see "horizontal category(axis labels)", click edit and choose the range having the dates 2006-2013 i.e A2:A9 maybe

 

[Dwayne6584]

If you have the blue line click on it and delete it. Then (Clicking in chart) go to chart tools, Click on select data. On the horizontal categories you will see the numbers 1 2 3 4 5 etc. click the edit button a new window appear and it says axis range, left click on the cell 2006 and drag down to last year and hit OK. That will take care of it

 

[Trouttrap2]

There are lots of ways to fix this. One way is to simply delete the cell contents header for year - meaning delete "Year". Then select the range again without the year in the field. That will force the first column without a header to be the X-axis. You can put the year back after the chart is generated.