How do you not lose past chart data

**Useless_w/_excel** · 02-24-2009, 05:36 PM

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?

**shg** · 02-24-2009, 05:39 PM

I think it would be pretty hard to guess without seeing what you're doing, don't you think?

**Useless_w/_excel** · 02-24-2009, 05:58 PM

Here is an uploaded blank template of what I'm refering to. It's not the current one that I am using (it's on my computer at home) and only has a 30 day chart on there but should provide a good example of what I'm talking about. The info for the chart is on the info tab towards the bottom.

**shg** · 02-24-2009, 06:05 PM

If you want to invest a little time explaining where the problem is, I'm happy to help. Reverse engineering a workbook that contains no data is not part of my plan, sorry.

**Useless_w/_excel** · 02-24-2009, 06:45 PM

I'll have to wait until I get home to get the complete version and will attach that. I was just going through and adding numbers in so that there would be some data in there to explain things better but then realized that I had added some more info to the charts and will need that in there also so that you can better see what I'm trying to keep from happening with the charts. I don't know any other way to explain it with words other than in my first post with past days data dropping off the chart messing up the overall total and each days total graphically. Thanks for your patience while working with me on this issue.

**Useless_w/_excel** · 02-25-2009, 05:32 PM

Ok so here's a filled out spreadsheet that goes well past 60 days. When you look at the graphs the TOTAL line doesn't match the actual total on the "Bankroll" Page. The data for the graphs can be found on the "Info" page. It's the long set of data near the bottom.

There is roughly 60 days of data collected there but my issue is that I have data that is farther out than 60 days that when lost, throughs off all the rest of the numbers. The top line for 'Cash' 'Tourney' and 'Total' should match what is on the 'Bankroll' page and it doesn't due to the lost data. Is there a way to include the past data in the graphs without having to keep extending the list as days go by?