I am trying to plot an XY scatter graph with 2 series from this data:

Year 1996 1997 1998 1999 2000 2001 2002 2003
National rail 761 801 846 892 947 957 960 976
London Underground 784 772 832 866 927 970 953 942

However, it picks up the cells in column B (values 761 and 784) with the
series labels so they show as 'National Rail 761' and 'London Underground
784' and the data points are missing from the series. When I try to correct
these by setting up the series X Values and Y Values I then get an extra data
point at 0 around 1996 and the X Values change to 1,2,3,4,5 despite me
setting up the year values as the X values and them definitely being in
number format (not date format). I've tried everything I can think of but
can't get Excel 2000 to behave itself, has anyone else had this problem?

Andrea Jones