abc MICROSOFT EXCEL 2010 - Pivot table
Changing data in pivot table

If we want ti change range data in pivot table it is done from PIVOT TABLE TAB, OPTIONS TAB, DATA group CHANGE DATA SOURCE button and coosen range.


Years!$A$1:$G$31
Years!$A$1:$G$11

Picture 1. bigger range of y data

Picture 1. Smaller range of y data
   

Picture 3. bigger range of y data

Picture 4. Smaller range of y data

 

Changing data in pivot table, steps:

  1. PIVOT TABLE TAB.
  2. OPTIONS TAB.
  3. DATA group.
  4. CHANGE DATA SOURCE button;
  5. Mark new data range;
  6. OK button;
  7. The end (Kraj).

 Index