Select the two columns (your cells u to f).
Insert/ Chart/ XY Scatter
Choose version with lines
Data in columns

That should work, but if not: Edit Source data and put your cells u to z as
your X series, and a to f as your Y series.
--
David Biddulph

wrote in message
oups.com...
Ok, I've struggled with this far too long now.
And abandoned the task a number of times over the past year.
So, I'm going to ask you now.


I have two columns of data:

u a
v b
w c
x d
y e
z f
etc.

Where u to z, and a to f represent numbers.


I want to see a simple graph with one column representing the
X axis, and the other column, representing the Y axis.

And a line, showing the relationship between the two.

It should be simple right? Unfortunately, it hasn't.

I've tried to create a scatter graph with lines.
And a line graph.

But excel just doesn't want to cooperate.
It wants to make each column a separate line.
Not the axis.


What is the secret please? I'm using Excel 97.


Thanks a lot!