Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add new data to a pivottable/chart?
I have a spreadsheet that I add new data to weekly. Is there a way to have
the pivottables/charts refresh to include this data without recreating them? If I try to do extend the range of cells used to create them originally, I am unable to group dates (which I need to do) on the chart because of blank cells. |
#2
|
|||
|
|||
You can use a dynamic range as the pivot table source, and it will
automatically expand as rows or columns are added. There are instructions he http://www.contextures.com/xlNames01.html When you refresh the pivot table, all the new data will be included. Brian Lee wrote: I have a spreadsheet that I add new data to weekly. Is there a way to have the pivottables/charts refresh to include this data without recreating them? If I try to do extend the range of cells used to create them originally, I am unable to group dates (which I need to do) on the chart because of blank cells. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |