Sum values when creating a graph

[Ritzyy]

If I have a list of values say

1
2
5
4
2
3

is it possible when graphing for my line graph to show a running total? so the points on my graph would go from 1 to 3 to 8 to 12 to 14 to 17.

I'd like to do this with a formula instead of creating an extra list next to it of running totals, then plotting that.

Using excel 2010 fyi

Thanks.

 

[Ritzyy]

Otherwise if I have to make the list of Sums, I'll make it on a hidden spreadsheet.

To do this I'd want to use the range A1 to A400 where 400 will change so i'll need code to do it. The number which I want 400 to be is equal to one cell value minus another. How do i use an indirect refrence in vba? I want to use the range Range("A1:A" & Sheet3!A5 - Sheet3!A3) but i'm not sure how to do this in VBA. If it was an excel formula i woudl just use indirect but from what I believe Indirect doesn't exist in vba?