Running sum in a lined chart

The issue is better described here: http://answers.yahoo.com/question/in...8025955AAT7mSK

My question is, is there a way to create a steadily rising lined chart (all numbers in the table are positive) with the existing numbers in a table? I could do it by creating a new table with running sums but I would like to use the existing numbers and some kind of a formula.

Example: a column with numbers 3 1 5 2 would translate into points 3 4 9 11 on a chart

I hope it is clear enough.

That looks like a good job for a fixed number of rows, but what if there is much more than 4 rows of numbers to add (let's say 100) and the range is expanding? Still possible this way or is it just more convenient to create an additional table? Thanks btw!

This formula has turned my Excel completely crazy, it was already slow and occasionaly 'not responding' when working with the name manager but now the formula has a life of it's own changing itself at will and sometimes crashing the program and claiming it is out of ressources. It will take me some time to figure out why. It's not like I have a slow computer, it's a core 2 duo processor which should do the job I expect it to do.

Ok, I have finally managed to make it work. It took some adapting to my real table which is more complicated than the example above. Another problem was the lacking $ in front of every letter and number in a reference which was making my whole computer go crazy with cpu and memory usage shooting up, Excel not responding, everything taking an eternity to display and not doing it correctly, formula changing itself miraculously, etc. The formula in my case is the equivalent of:

=SUBTOTAL(109,OFFSET(Sheet1!$A$1:$A$4,,,ROW(Sheet1!$A$1:INDEX(Sheet1!$A:$A,COUNT(Sheet1!$A:$A))),))

It's still a bit slow and buggy (deleting a number in a table sometimes freezes the chart in it's current position and only restarting Excel helps) but I put it down to the name manager (for whatever reason), not the formula. Thanks to both bebo and Ace.