Change Axis titles in Excel 2007

[tom_the-confused]

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

 

[Bernard Liengme]

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

 

[tom_the-confused]

Thanks Bernard,

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

Tom

 

[Jon Peltier]

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

 

[tom_the-confused]

Hi

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

Tom