# Two data series with different categories in one chart

Koen
1 1 1 1

How can I put two series of data(all happening in the same period of time but on different times and dates) in one chart with the lines between the dots not being interupted. I have a list of dates+times in column A in column B I have values of those dates+times. In column C I have another list of dates+times and in column D the values that belong to the dates+times in column C. How can I display those two series of data in one chart while there will still be lines between the dots of the first series and lines between the dots of the second series?

delete close retag edit

Do you mean that you want all the data to be seen as a single data set in the plot, or as two separate series? Pedro's answer gives you the second. In both cases: use XY(scatter) plots when you have a real dataset where x is more than just a counter, it gives better results.

( 2012-05-10 17:22:28 +0200 )edit

Do you mean that you want all the data to be seen as a single data set in the plot, or as two separate series?

( 2012-05-10 17:22:28 +0200 )edit

Sort by » oldest newest most voted

Pedro
3218 4 23 54

You need to reorganize your data. The first column should be the dates. Then have separate columns for the values of variable A and B. e.g

Use an XY (scatter) plot with lines instead of a Line Plot.

Would like to point out here too: Using XY(scatter) plot is the main issue here, I think. Note that in creating a diagram, you can tweak what field is used for labels, X- or Y- values (combining multiple columns with a ";" between them is easy too), though that might get more complex than you'd like

( 2012-05-10 17:33:14 +0200 )edit

## Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!