Sum up series in a graph.

[4ndroid]

Hello guys.
So this is my first post.

I have crated a chart with 4 different series. X axis is a value (in this case money), and Y axis is a date.
The four different series comes from 4 different tables.

Each serie stands for money on a account shown over date and total amount of money on each date.
So I have four different accounts here that I am following in this graph with four series.

So what I need help with;
I want to be able to see a 5th serie/line in my graph which would me the sum of all the other four graphs.
I want to see how much cash I have on all the accounts, together, buy the given date.

I have figured out how to do this in the complicated way, which would be to make a 5th table and then make my 5th serie.
In order to do so I had to take all the four tables and put the dates in right order so that the value will be correct. This is annoying.

How can I directly sum up my four series with each other to create the 5th one?

Difficult to explain, but here's a picture that shows what I made.
http://postimg.org/image/lo9i8kpi3/full/

Just ask me whatever you need!

Thanks in advance

[MrShorty]

It is difficult to work with a picture. A sample Excel file (with dummy data in place of the real data) would be easier for us to see what you are trying to do.

I want to be able to see a 5th serie/line in my graph which would me the sum of all the other four graphs.

Excel charts don't really analyze data for us. When we want this kind of analysis, we need to perform the analysis in the spreadsheet (like you are doing) then add that information to the chart.

With that in mind, when I find the creation of the 5th series "annoying", I look at two things:

1) The process I am using to create the 5th series -- Is there a better (or at least less annoying way to do it)
2) The original data's arrangement in the spreadsheet -- Can I arrange the raw data in way that makes the summation easier (or at least less annoying)

What do you find "annoying" about creating the 5th series? It appears to me that it should be relatively simple lookup functions to extract the data from the original four tables into the 5th table, so the functions should not be difficult. What functions are you currently using to get the 5th series?

[4ndroid]

Hello Sir and thank you for the feedback.

I have created an excelfile with dummy data.

In sheet1 you see my four bank accounts, and to it you see the graphs.
From my bank account i extract the following information: Date, Explenation, Nevermind (another date), cash out, cash in
I just cut and paste these five things, quick and easy. Id like to keep it that way, when theres a lot information to add to the cheat, this would be the easy way.
Out of cash in and out (D and E) I create balance at the given date (L). Further I use the date (A) and balance (L) in to my graph.
This I repeat for the four accounts.

Now I'd like to create the fifth serie in my graph which shows the total balance of all the accounts. I do not care if I need to create a table (I dont need it), as long as I get the four series and the fifth one into one graph, I am satisfied.

In sheet2 you see my atempt. I have manually created the fifth table, buy manually putting the dates in right order. This I find annoying.
If I now have to, how do i create the fifth table with all the dates in right order (together with the five things (Date, Explenation, Nevermind (another date), cash out, cash in) or with just Date (A) and Balance (L)).
And then I have simply putted the data from the fifth table to my graph.

Thanks again