What is a general technique for handling the follow situation? I use pivot
tables and pivot charts to analyze a dataset. Each week, the dataset's
record count increases (thus the rows the pivot table uses expands).

I want to avoid manually re-building the pivot table and pivot charts each
week and would like the pivot table's range to expand automatically to
include all records.

It appears using named ranges in the pivot table definition is not
allowed. Also, I want to avoid using macros if possible.