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 |
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. |
All times are GMT +1. The time now is 12:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com