Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Tables & changing data
Hi - I have never used pivot tables in Excel before so hopefully what I am
going to ask is possible and not too complicated for me.... :o) I am working with Excel 2003. I have a pivot table already set up and the information is pulling data from a row titled "sum of Subscriber". I added new data in a new column from the main spreadsheet and I would like to pull the data from there. Its titled "Adj Subscriber". Is it possible to switch it? If so, how? Thanks, Anna Marie |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Tables & changing data
Anna wrote:
Hi - I have never used pivot tables in Excel before so hopefully what I am going to ask is possible and not too complicated for me.... :o) I am working with Excel 2003. I have a pivot table already set up and the information is pulling data from a row titled "sum of Subscriber". I added new data in a new column from the main spreadsheet and I would like to pull the data from there. Its titled "Adj Subscriber". Is it possible to switch it? If so, how? Thanks, Anna Marie Click somewhere in your PT. Go to Data | Pivot Table... to open the PT wizard. Click Back. Now you can redefine the data range to include your new column. Finish, and your new column should appear. You may know the next step already, but just in case... Go to Data | Pivot Table... to open the PT wizard again. Click Layout. Now you can remove the old column and insert the new. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I keep my pivot tables format from changing? | Excel Discussion (Misc queries) | |||
Changing Data Source on Multiple Pivot Tables at once | Excel Worksheet Functions | |||
pivot tables changing their formats when data is refreshed | Excel Discussion (Misc queries) | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) |