It is too tedious to have to go in and manually type in the new cell
references to update charts weekly. Is there a way to automate the process?
If I could simply reference the new dates or something with maybe a macro
would help. I am not conversant in Visual Basic, but an quite skilled in
Excel.

Thanks,

KIOhio