Ask Your Question

Multiple graphs in one chart [closed]

asked 2013-02-20 15:30:42 +0200

BenKen gravatar image

updated 2015-10-23 13:49:10 +0200

Alex Kemp gravatar image

I have two sets of Data:

Total balances of account 1 with their respective dates and total balances of account 2 with their respective dates. Of course the dates of the data for account 1 and account 2 can be very different.


Dates of Account 1: 01.01.01; 02.01.01; 30.01.01

Balances of Account 1: 0$; 2$; 3$

Dates of Account 2: 01.01.01; 05.01.01; 25.01.01

Balances of Account 2: 2$; 5$; 3$

Now I want to create a Chart where I can see the balance of each account at each time (connected with normal lines). (So e.g. blue line is for Account 1 and red line is for Account 2, since both balances are in a similar range, these two lines should be next to each other horizontally)

What is a good and particularly flexible approach? (Later on, I might add more data to each dataset)

Edit: Thanks for the answer so far. The problem is that Account 1 and Account 2 can have different dates.

So Account 1 has dates: 1. Jan, 2. Jan, 30. Jan

And Account 2: 1. Jan 5. Jan, 25. Jan

I don't want to fill in the missing dates and I have many many X values, so it's not feasible to use markers.

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-23 13:51:01.705456

3 Answers

Sort by » oldest newest most voted

answered 2013-02-20 17:47:16 +0200

TrickyHarry gravatar image

updated 2013-02-20 17:52:31 +0200

Why not us the line graph chart, using the date as the x-axis you can draw to two line graphs. You can use markers to indicate actual dates.

Sorry I cannot upload a sample, not enough Karma :-)

edit flag offensive delete link more


I try to give you some karma. Your proposal is perfectly right!!! If you cannot attach due to insufficient karma, try to attach a screenshot into your answer. However i don't know how much karma is needed for that

ROSt52 gravatar imageROSt52 ( 2013-02-21 04:16:31 +0200 )edit

@ROSt52, I believe one needs 3 karma points to upload a file.

qubit gravatar imagequbit ( 2013-03-08 08:02:53 +0200 )edit

@qubit - How to give 3 karma points? I really don't understand the karma system yet. Clicking on the UP or DOWN arrow give how many karma points? How are given when the question is right?

ROSt52 gravatar imageROSt52 ( 2013-03-08 09:21:47 +0200 )edit

@ROSt52 -- I think that most of your questions can be answered by the faq. Ping me back if you have more q's :-)

qubit gravatar imagequbit ( 2013-03-08 09:24:51 +0200 )edit

answered 2013-02-21 04:12:48 +0200

ROSt52 gravatar image

updated 2013-02-21 04:14:07 +0200

you can easily have even more than 2 accounts. I created an example. Screenshot should explain all what is needed.

image description

edit flag offensive delete link more

answered 2013-02-24 03:01:15 +0200

horst gravatar image

updated 2013-02-24 03:05:31 +0200

Instead of using a Line-chart use a x-y-chart. Set the spreadsheet up as ROSt52 suggested but don't care about filling the dates up. You can have 2 1.Jan `

Date  Acc1  Acc2
1.Jan $1.-
5.Jan $3.-
1.Jan       $3.-
3.Jan       $4.-

With x-y-chart it does'nt matter where the dates (x-values) are. I hope you get the idea.

BTW x-values are the dates, y1..yn are the account values.

edit flag offensive delete link more


@BenKen -- Does @horst's Answer work for you?

qubit gravatar imagequbit ( 2013-03-08 08:06:59 +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:47:19 +0200 )edit

Question Tools


Asked: 2013-02-20 15:30:42 +0200

Seen: 21,174 times

Last updated: Feb 24 '13