Updated Data in Pivot Chart/Table

[Beverly Mott]

I have a series of pivot charts and tables in a worksheet that also contains the raw data, in another tab.

I need to add data to the raw data sheet every month and have the pivot charts and tables use both the older data and the newer data.

It sounds easy but I just can't figure out how to do it or even how to research the question.

[#2]

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