I've got a 30 day and a 60 day chart that each day adds the previous day's total to what was either gained or lost for the day. In other words it keeps a running total of everything. My problem is that I've gone past the 60 day mark and the charts are now incorrect because it has lost past days totals to add into the first day of the chart. Is there any way to prevent this from happening?
For example: Starting with Day 1 @ a value of 60
Day 2 gain 20 so the total is 80
Day 3 loss of 30 so total is 50.....
61 days later I lose day 1's value and day 2 becomes day 1 giving me a starting total of 20.
I've lost a value of 60 throughout the rest of my chart.
62 days later I lose day 1's value again and day 3 becomes day 1 giving me a starting total of -30.
How to I prevent this from happening?
Bookmarks