View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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??