Ask Your Question
1

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

asked 2012-02-20 22:43:03 +0200

Koen gravatar image

updated 2014-02-12 00:40:50 +0200

bencomp gravatar image

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 flag offensive 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

Comments

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 gravatar imagebosyber ( 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?

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

1 Answer

Sort by » oldest newest most voted
3

answered 2012-02-21 12:18:45 +0200

Pedro gravatar image

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

image description

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

edit flag offensive delete link more

Comments

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 gravatar imagebosyber ( 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.

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

Question Tools

Stats

Asked: 2012-02-20 22:43:03 +0200

Seen: 13,781 times

Last updated: Feb 12 '14