plotting several overlapping data ranges on an XY plot

[nazg00l]

Is there any way to plot several data series on a common XY chart? Individual series cover the same X range, but the actual sampling points are different so there is no way to bring them to a "common X" format.

Simply specifying the ranges separated with semicolons produces a chart that looks OK, but all the series are treated as the same data range and therefore cannot be formatted individually. Not to mention that the end of one series gets connected with a line to the start of the second series and so on. How can this be done? It is a trivial function in plotting software like Origin or Grapher, but I can't seem to find an "Add Data Series to Chart" function in Calc... I have searched the Net, but can't find anything useful.

Any help will be greatly appreciated!

Andrzej Sawula

[jrkrideau]

[nazg00l]

OK, so an example would go like that:

Two series of data, both covering the 0-10 X range.

Series 1:

[David]

This is a digital machine, so you can't get continuous "real" values". In that case, determine at first your required accuracy [and it is a graph, so you won't see minute differences over a large amount of data.] With that in mind, suppose you set up a list of values down column A, such as 0, 0.1, 0.2, 0.3, .... Yes, you'll have a hundred, but there's lots of room and assitance with that by dragging a series. Then you can have one set of relational results in column B and another in column C. Choose all to draw the graph, then change axis values later [steps of 1?]

Personally, I'd use available math programs for this sort of thing, not a spreadsheet. I've mentioned a couple in the recent and distant past

David.

[jrkrideau]

[nazg00l]

Yes, that should not matter - but it does. When processing a 2nd series of data, Calc expects the Y data to correspond to the 1st column X values, not to their own specified ones...
EDIT: I found a way to do this. Somewhat counterintuitive and limited, but still... The solution is to insert X data in the 1st column and then individual series of Y data in individual columns, like that:

[jrkrideau]