Pivot Tables / Pivot Chart Data

Select the Pivot table and use, Pivot Table Tools > Options > Data > Change Data source.

If you convert your source data in to a Table and link the pivot table to it then the expansion for new data should be automatic.