Year-To-Date Data Updating

[tastyscoob]

I'm keeping records of incoming call amounts for my company. I've been keeping them for just 2 weeks shy of a year. Every week, I've just filled in the weeks sumation in the next column to the right. I've got all kinds of sums, averages, titles, and a few "hidden" numbers used for calculations. I've also got 8 or 9 charts linked to the data table I've been assembling. As is, at the end of the week, I sum up the weeks work, input into the new column, all my sums, and averages work themselves out, then I have to go into each chart and update the sources to reflect all the data I've collected, plus the new column. Now that I'm reaching the year mark, I'd like to keep it at a Year-To-Date level. I'd like to be able to just delete the first week, add a new week and not have to change the source data for the charts. OR, If I can keep on adding new weeks, but only display the last years worth of data in the charts without having to change the source data either, would be great as well. Any ideas...? If you need more info, let me know as well!


Thanks,

 

[tastyscoob]

Any advice would be appreciated!

 

[PaddyD]

welcome to the board.

sounds like your data's in a mess, but I might be wrong. Does your worksheet proceed:

data | calculations

or is it:

data | cualculations | more data.

I ask, because if you have all you data in one contiguous area, it is fairly straightforward to get the running totals thing. You can also set up your graphs so they automatically update - see the dynamic chart example here:

http://www.tushar-mehta.com

To make any progress here, post back with more info - how the new weeks are identified (with dates as column headings ? are they proper dates or just text...etc). You might consider posting a representative snapshot of your data using the html marker addin from the link below this post.

Paddy


Paddy