Pivot Tables & changing data

[Anna]

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.... )

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

 

[smartin]

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.... )

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.