stupidly easy question
Hi
Right click on your graph and choose Source data.
Click on Series Tab
Delete Series 1 Years, and juts have series for Millions.
Click icon at the end of the Category (X) axis labels, and point to
B1:G1
Click OK
--
Regards
Roger Govier
"leppel" wrote in message
...
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!
--
leppel
|