Hi

Thanks Jon - the answer lay in the edit data button and then edit the
horizontal axis.

Tom

"Jon Peltier" wrote:

What kind of chart is it?

Click on the series, and read the formula bar. It should read something like
this (correct for actual sheet name and ranges):

=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$8,Sheet1!$B$2:$ B$8,1)

If not, Excel didn't correctly guess what you wanted to plot. You can click
the Edit Data button on the first chart tab, then change the various ranges
indicated for series data and category labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"tom_the-confused" wrote in
message ...
Thanks Bernard,

But that's the layout of the spreadsheet I've created.

Tom

"Bernard Liengme" wrote:

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