Line Graph Issues

[tbeigi]

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

Year	FSR Redeeming Operators
2006	1,203
2007	8,839
2008	14,984
2009	20,229
2010	30,216
2011	33,761
2012	34,448
2013	34,846

<colgroup><col><col></colgroup><tbody>
</tbody>

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.