This has really aided my job search and created ample opportunities.”

Online Learner

Creating Opportunities For A Better Life.®

Excel 2007

Single page view print copy

Creating Pivot Tables

Moving, or pivoting, data:

  • Click and drag a field from one area to another.
Move Data

 

  • Release the mouse button to drop the field in the new area. In this example, we move Region from Report Filter to Column Label. The PivotTable report will change.
Move Data Part II


OR

  • Right-click one of the rows. A menu will appear.
  • Select Move, then select a move option.
Right-Click Menu

To create a PivotChart

  • Select the PivotChart command from the Options tab. The Insert Chart dialog box appears.
PivotChart

  • Select the chart you’d like to insert.
  • Click OK. The chart will now appear on the same sheet as the PivotTable.

The information in the chart includes the information in the PivotTable rather than all of the original source data.

1 2 3 4 5