Excel Timeline Chart

[Threshold]

Hi All,

Having a little trouble, trying to create a line chart based on dates and sum.
I've created a pivot chart to group all the same dates and sum them together per person.

[TABLE="width: 580"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Sum of Amount[/TD]
[TD]Column Labels[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]Q[/TD]
[TD]S[/TD]
[TD]V[/TD]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Z[/TD]
[TD]Grand Total[/TD]
[/TR]
[TR]
[TD]2/15/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $ 20.00[/TD]
[TD] $ 5.00[/TD]
[TD] $ 12.00[/TD]
[TD] $ 37.00[/TD]
[/TR]
[TR]
[TD]2/16/2015[/TD]
[TD] $ (1.00)[/TD]
[TD] $ 12.00[/TD]
[TD] $ 15.00[/TD]
[TD] $ (6.00)[/TD]
[TD] $ (5.00)[/TD]
[TD] $ 13.00[/TD]
[TD] $ 28.00[/TD]
[/TR]
[TR]
[TD]2/17/2015[/TD]
[TD][/TD]
[TD] $ 1.00[/TD]
[TD][/TD]
[TD] $ (5.00)[/TD]
[TD][/TD]
[TD][/TD]
[TD] $ (4.00)[/TD]
[/TR]
[TR]
[TD]2/18/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD] $ (15.00)[/TD]
[TD][/TD]
[TD][/TD]
[TD] $ (2.00)[/TD]
[TD] $ (17.00)[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD] $ (1.00)[/TD]
[TD] $ 13.00[/TD]
[TD] $ - [/TD]
[TD] $ 9.00[/TD]
[TD] $ - [/TD]
[TD] $ 23.00[/TD]
[TD] $ 44.00[/TD]
[/TR]
</tbody>[/TABLE]

Now what I want is for it to sum up as the days go on, so in the case of person X, gained 20 on the 15th, so it shows a positive 20, then they lost 6 on the 16th, so instead of showing -6, I want the graph to show a +14 on the 16th, then on the 17th lost 5 so a +9 on the chart and so on, if they have nothing it stays where its at so like on the 18th no loss or gain, so it still stays +9 on the line chart.

Any suggestions?

Thanks in advance!

 

[Misca]

Looks like you're looking for running totals: Right click your values field on your pivot table and choose "Show values as", choose "Running total in" and set your base field to dates.