# Multiple graphs in one chart [closed]

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.

E.g.

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

Sort by » oldest newest most voted

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 :-)

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

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

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

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

( 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 :-)

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

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

more

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.

more

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

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

( 2016-03-27 09:47:19 +0200 )edit