Updated Data in Pivot Chart/Table

Hi Beverly,

it is best to keep your raw data in a table, and create pivot tables and charts from it. Any additional data added to the end of the table would then be automatically picked up upon pivot table/chart refresh, provided 

I suspect your raw data is organised in a range. It is best to first convert it to table (click on a cell inside the range, then Ctrl+T). Subsequently, click on a pivot table linked to the raw data, then go to PivotTable Tools>Analyze>Data>Change Data Source. This will open the 'Change PivotTable Data Source' windows, where you can select the data area of your table. When done properly, the Table/Range windows should show the table name (you can also type it in yourself). After clicking OK, you pivot table should be picking up new data added to your source table.

Hope this helps

Yury