Automation of change of data range

[KIOhio]

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

 

[KIOhio]

Update, I neglected to mention Excel 2007.

 

[KIOhio]

HELLO--Anybody--I still need help, please.

 

[Andy Pope]

Hi,

Have read up on dynamic named ranges.
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

 

[KIOhio]

Thanks so much. I am going to do some reading now. This looks like my answer.

Dan D. Brown