Okay, I'll ask again: What's the data look like?

Before creating the chart you should have two columns, with the years to the
left of the values you are plotting. Put a label atop the column of values,
and a blank cell atop the column of years (resist the urge to enter "Year").
The blank cell helps Excel parse the data into X values, Y values, and
series name.

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


"sssssmmmmm" wrote in message
ps.com...
hi, thanks for reply. i tried that but it didn't help. i've managed to
find a way around it now which was by formatting the years into text,
so the graph no longer treats them as having any values. i can now
have either sets of data on either axis. while it has found a way
around the problem it still didn't get to the bottom of it. Thanks
for the help anyway!