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?
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
bosyber ( 2012-05-10 17:33:14 +0200 )editLibreOffice 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!
Asked: 2012-02-20 22:43:03 +0200
Seen: 2,315 times
Last updated: Feb 21 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
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.
bosyber ( 2012-05-10 17:22:28 +0200 )editDo you mean that you want all the data to be seen as a single data set in the plot, or as two separate series?
bosyber ( 2012-05-10 17:22:28 +0200 )edit