How can I put two data series with different categories in one chart?

[Koen1]

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?

[bosyber]

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]

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?

[Pedro1]

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.

[bosyber]

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

[oweng]

While the answer here may be effective, a Line chart should be used unless there is an intrinsic relationship between the x,y value pairs e.g., a pair of related measurements for a given date. An XY (Scatter) chart uses a separate (3rd) column to represent the category. Refer the answer here.