en uk

Creating a pivot table Microsoft Excel 2007

    Pivot tables use the column headings of a spreadsheet to organize data in a table. Ideally, each column in the spreadsheet should identify a different type of data, such as the name of each salesperson, the sales region he or she works in, and the total amount of sales made, as shown in Figure 9-10.

    Creating a pivot
table Microsoft Excel 2007

    Figure 9-10:

    Before you create a pivot table, you must create a spreadsheet where each column identifies a different set of data.

    After you design a spreadsheet with multiple columns of data, follow these steps to create a pivot table:

    1. Select the cells (including column labels) that you want to include in your pivot table.

    2. Click the Insert tab.

    3. Click the PivotTable icon in the Tables group.

    The Create PivotTable dialog box appears, as shown in Figure 9-11.

    Creating a pivot
table Microsoft Excel 2007

    Figure 9-11:

    Define the cells to use and a location to place your pivot table.

    4. (Optional) Select the cells that contain the data you want to use in your pivot table.

    You only need to follow Step 4 if you didn't select any cells in Step 1, or if you change your mind and want to select different cells than the ones chosen in Step 1.

    5. Select one of the following radio buttons:

    New Worksheet: Puts the pivot table on a new worksheet

    Existing Worksheet: Puts the pivot table on an existing worksheet

    6. Click OK.

    Excel displays a PivotTable Field List pane, as shown in Figure 9-12.

    7. Mark (select) one or more check boxes inside the PivotTable Field List pane.

    Each time you select another check box, Excel modifies how data appears in your pivot table, as shown in Figure 9-13.

    Creating a pivot
table Microsoft Excel 2007

    Figure 9-12:

    The PivotTable Field List pane lets you choose which data to display in the pivot

    Table.

    Creating a pivot
table Microsoft Excel 2007

    Figure 9-13:

    Adding column headings increases the infor­mation a pivot table displays.




BACK NEXT TOP

Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.