Microsoft Office Tutorials and References
In Depth Information
Creating a Pivot Table
Specifying the Data
If your data is in a worksheet range or table, select any cell in that range and then choose
PivotTable, which displays the dialog box shown in Figure 18-7.
Figure 18-7: In the Create PivotTable dialog box, you tell Excel where the data is and then specify a location
for the pivot table.
Excel attempts to guess the range, based on the location of the active cell. If you’re creating a
pivot table from an external data source, you need to select that option and then click Choose
Connection to specify the data source.
If you’re creating a pivot table from data in a worksheet, it’s a good idea to first create
a table for the range (by choosing Insert➜Tables➜Table). Then, if you expand the table
by adding new rows of data, Excel will refresh the pivot table without you needing to
manually indicate the new data range.
Specifying the location for the pivot table
Use the bottom section of the Create PivotTable dialog box to indicate the location for your pivot
table. The default location is on a new worksheet, but you can specify any range on any
worksheet, including the worksheet that contains the data.
Click OK, and Excel creates an empty pivot table and displays its PivotTable Field List, as shown
in Figure 18-8.
The PivotTable Field List is normally docked on the right side of Excel’s window. By
dragging its title bar, you can move it anywhere you like. Also, if you click a cell outside
the pivot table, the PivotTable Field List is hidden.