KDE-Forum.org

Say I have two columns of data. The first column is what I want on the x-axis and the second column is what i want on the y-axis. How can I produce a line graph of this data?

Both Excel, Gnumeric, and OpenOffice Calc let you select the cells and graph a line graph, but I've never been able to do this with KSpread.

Sample Data:

Col1 Col2
1 .8
2 1.2
3 .6
4 1.6

I looked in the Handbook/Help for KSpread but it wasn't much help.

If there is more documentation that I should look at please let me know.

Thanks, Mike

Not sure I made myself clear.

I have two columns, column 1 is what I want on the X-axis and column 2 is on the Y-axis

So if I have the following data,

Column 1 Column 2
1 3.2
2 2.3
3 1.8


I want a graph like (forgive the ascii graphics), the _'s are for spacing stuff.

3|__*
_|_________*
2|
_|_________________*
1|
_|
0|__________________________
____1______2_______3

With a line through the asteriks.

What KSpread gives me is three lines one from 1 to 3.2, a second from 2 to 2.3 and a third from 3 to 1.8. This is totally wrong.

If I select the two columns of data in any other spreadsheet and create a line graph it gives me what I want.

What am I doing wrong? Or is graphing in KSpread handled differently than any other?