You are not logged in.

Dear visitor, welcome to KDE-Forum.org. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

1

Monday, February 2nd 2004, 9:46pm

KSpread Graphing

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

seb

Professional

Posts: 622

Location: Sydney

Occupation: Student

  • Send private message

2

Tuesday, February 3rd 2004, 2:23am

From the menubar:

Insert >> Object >> Chart

use the crosshair to draw a box and to position the location of the graph

clicking on the graph box, the toolbar will change to the graph toolbar. Click on the desired type of chart, or on the wand to go through the wizard.

hth,
Seb

3

Tuesday, February 10th 2004, 3:06pm

Graphing in KSpread

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?