# How can I put two data series with different categories in one chart? [closed]

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?

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-10-05 20:39:00.643862

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

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.

more

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

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.

( 2016-03-27 09:39:20 +0200 )edit

## Stats

Seen: 13,792 times

Last updated: Feb 12 '14