Openoffice.org spreadsheet question

[baseballer10p]

I'm trying to make a graph in openoffice 2.0 with different series of data in the same graph. All that I can manage though is getting all of my data in one series, which I don't want. Is there any way that I can get more than one series of data on the same graph? Thanks.

[pam123]

I'm confused.
You've got different set of data and you've done a graph for each?
Now you want to merge the data on to one graph?
I think you skipped a step.

[baseballer10p]

What I want to do is put more than one line on the same graph. It's not really three different sets of data. I want to do something like put different series on the same graph like you can do in excel using the series tab in the first step.

[pam123]

Where are you in calc (I can guess but it's better if I don't) ?

[baseballer10p]

I have my data on the table, then I click on insert chart.

[baseballer10p]

here is the data

i need one line for the cold water temp and time, one line for the hot water temp and time, and one line for the mixture temp and time. this needs to be on one scatter plot chart

[pam123]

The file isn't working.:confused:

[baseballer10p]

huh. i guess ill try it again.

cold temp--------hot temp--------time--------mixture
13.2---------------38.4---------------1-----------------------
13.3---------------37.8---------------2-----------------------
13.3---------------37------------------3-----------------------
13.4---------------36.6---------------4-----------------------
13.5---------------35.9---------------5-----------------------
------------------------------------------6-------------25
------------------------------------------7-------------24.9
------------------------------------------8-------------24.8
------------------------------------------9-------------24.7
------------------------------------------10-----------24.6
------------------------------------------11-----------24.5

[pam123]

It looks like you need to use Graphic(It's under Format.).
That will arrange your data as points on a sheet of graph paper (connect the dots sort of thing)
Which means hot, cold, and intermediate will all be there along with time.