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.
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
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!
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.
Sum of Amount | Column Labels | ||||||
Row Labels | Q | S | V | X | Y | Z | Grand Total |
2/15/2015 | $ 20.00 | $ 5.00 | $ 12.00 | $ 37.00 | |||
2/16/2015 | $ (1.00) | $ 12.00 | $ 15.00 | $ (6.00) | $ (5.00) | $ 13.00 | $ 28.00 |
2/17/2015 | $ 1.00 | $ (5.00) | $ (4.00) | ||||
2/18/2015 | $ (15.00) | $ (2.00) | $ (17.00) | ||||
Grand Total | $ (1.00) | $ 13.00 | $ - | $ 9.00 | $ - | $ 23.00 | $ 44.00 |
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
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!