You need to make a table like this
year data
1999 101
2000 102
2001 103
2002 104
2003 105
2004 106

but delete the header year
Make chart for this data
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"tom_the-confused" wrote in
message ...
Hi,
I've created a chart from a spreadsheet in Excel 2007. I want the
horizontal
axis to show the year (1995 to 2002), currently it just shows 1,2,3,4,5,6
&7.
How do I achieve this?
Thanks
Tom