Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables in excel
Hi, kind of new to pivot tables. What I would like to know is after one
creates a pivot table. And then I decide I need a new extra colum that will still be connected to the pivot table. Well how do I do that?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables in excel
To add field:
Right-click on table, show field list, drag the field you want into your report. Adding a column to raw data that feeds PivotTable: Right-click on table, view wizard, click 'back' until you get to the data selection window. Increase the size as needed, then hit 'finish'. (note that you then need to add the field as well) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "sword_fishx" wrote: Hi, kind of new to pivot tables. What I would like to know is after one creates a pivot table. And then I decide I need a new extra colum that will still be connected to the pivot table. Well how do I do that?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables in excel
Hi,
Assuming you have just added a new column to the raw data, to the right of the old data, choose PivotTable, Chart Wizard, Back then hold down the Shift key and press the right arrow once, click finish. In 2007 right-clicking will not give you access to the needed command (why?). Instead, select the pivot table and choose PivotTable Tools, Options, Change Data Source... -- If this helps, please click the Yes button. Cheers, Shane Devenshire "sword_fishx" wrote: Hi, kind of new to pivot tables. What I would like to know is after one creates a pivot table. And then I decide I need a new extra colum that will still be connected to the pivot table. Well how do I do that?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables in excel
Hi Luke M,thank you for your help
"Luke M" wrote: To add field: Right-click on table, show field list, drag the field you want into your report. Adding a column to raw data that feeds PivotTable: Right-click on table, view wizard, click 'back' until you get to the data selection window. Increase the size as needed, then hit 'finish'. (note that you then need to add the field as well) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "sword_fishx" wrote: Hi, kind of new to pivot tables. What I would like to know is after one creates a pivot table. And then I decide I need a new extra colum that will still be connected to the pivot table. Well how do I do that?? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables in excel
Hi Shane thank you for your help "Shane Devenshire" wrote: Hi, Assuming you have just added a new column to the raw data, to the right of the old data, choose PivotTable, Chart Wizard, Back then hold down the Shift key and press the right arrow once, click finish. In 2007 right-clicking will not give you access to the needed command (why?). Instead, select the pivot table and choose PivotTable Tools, Options, Change Data Source... -- If this helps, please click the Yes button. Cheers, Shane Devenshire "sword_fishx" wrote: Hi, kind of new to pivot tables. What I would like to know is after one creates a pivot table. And then I decide I need a new extra colum that will still be connected to the pivot table. Well how do I do that?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pivot Tables | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
new to using pivot tables and excel | New Users to Excel | |||
Excel and Pivot Tables | Excel Discussion (Misc queries) | |||
Excel Pivot tables | Excel Discussion (Misc queries) |