Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
update pivot table data range
I have a pivot chart based on A1 thru D10 in and Excel 2003 workbook. I
would like to expand it to A1 thru F20, but I don't see how that gets done. How do you respecify the data range for the pivot table? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
update pivot table data range
Hi,
Select the pivot table and choose Data, Pivot Table and Pivot Chart Report, click Back once. Your there. I will send a more lengthy, but better solution in the next email. -- Thanks, Shane Devenshire "JN" wrote: I have a pivot chart based on A1 thru D10 in and Excel 2003 workbook. I would like to expand it to A1 thru F20, but I don't see how that gets done. How do you respecify the data range for the pivot table? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
update pivot table data range
Hi again,
The base way to handle expanding data range for pivot table in 2003 or 2007 but not earlier versions is: 1. Define the data range as a List (2003) or Table (2007) by choosing Data, List, Create List, OK. Or press the shortcut key Ctrl+L (or in 2007 Ctrl+T also). 2. You can do this before or after you create the pivot table. 3. When you want to add new data move to the bottom of your list and enter or copy the new data directly below the last row of the list. The list will automatically incorporate the new data. And the pivot table will know about the new range! 4. Refresh the pivot table. -- Thanks, Shane Devenshire "JN" wrote: I have a pivot chart based on A1 thru D10 in and Excel 2003 workbook. I would like to expand it to A1 thru F20, but I don't see how that gets done. How do you respecify the data range for the pivot table? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to update data from pivot table | Excel Worksheet Functions | |||
update a Pivot Table with new data added to the base data | Excel Discussion (Misc queries) | |||
Pivot Table Data did not update | Excel Worksheet Functions | |||
How do I set the pivot table to auto-update the data range? | Excel Discussion (Misc queries) | |||
update the underlying data source of a pivot table | Excel Discussion (Misc queries) |