for example:

Year 1980 1985 1990 1995 2000 2005
Millions of Gallon 1750 3500 4000 4000 5100 11000

this is in the spreadsheet, but it always thinks the year is a value, and puts it in the graph as "series 2", and along the x axis it just puts 1 2 3 4 5 instead of the years....

thanks in advance!