Plotting a Running Total (without an intermediate table)

[DashboardNovice]

In the attached file, I want to plot four data series (each in a different color). However, as I plot each series, instead of plotting each value under the Cost column, I would like to plot a running total for each data series.

I can do this by creating an intermediate table, however I am wondering if it is possible to plot running totals directly from the source table.

 

[Faseeh]

I believe the best way is to use a secondary table. May be you can put that in some other sheet to avoid clutter, but the effort that you will put in to get this from one shot formula may be too much.

 

[DashboardNovice]

I believe the best way is to use a secondary table. May be you can put that in some other sheet to avoid clutter, but the effort that you will put in to get this from one shot formula may be too much.

If I were to try doing this with a formula, where on the chart would I enter the formula?

 

[Faseeh]

I believe you will have to do so by Defining a Name - and there you will create a formula that will yield the cumulative figure for each month. When you will be asked to plot a series, you will be using that Name.