Change Axis titles in Excel 2007

  • Thread starter Thread starter tom_the-confused
  • Start date Start date
T

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
 
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
 
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
 
Hi

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

Tom
 
Back
Top