Smintey,

It sounds like you need to create an X-Y Scatter chart with the series set
as "columns". Once the chart is created, double-click on the points and go
to Format data Series - Patterns - Line = Automatic. That should set your
line.

---
John Mansfield

"smintey" wrote:

I have a spreadsheet with two collumns of numbers in collumns A and B. I want
to produce a chart where collumn A produces the X axis values and B produces
the Y values. I want excel to plot the points where the values are and create
a line chart by joining these points up. I cant seem to get it to work!
Does anyone have any ideas???
Oh and if it makes a difference some of the values in the A (X axis) collumn
are negative so the chart would need to be able to display the negative
values in hthe x axis aswell.

Thanks in advance everyone!

Steve