Microsoft Office Tutorials and References
In Depth Information
Step 3: Completing the pivot table
Figure 9-6: In Step 2, you specify the data range.
If you place the cell pointer anywhere within the worksheet database when you
select Data
PivotTable Report, Excel identifies the database range automatically in
Step 2 of the PivotTable and PivotChart Wizard. You can use the Browse button to
open a different workbook and select a range. To move on to Step 3, click the Next
button.
If the source range for a pivot table is named Database , you can use Excel’s
built-in Data Form to add new data to the range. The named range will
extend automatically to include the new records.
Step 3: Completing the pivot table
Figure 9-7 shows the dialog box for the final step of the PivotTable and PivotChart
Wizard. In this step, you specify the location for the pivot table. If you select the
New worksheet option, Excel inserts a new worksheet for the pivot table. If you
select the Existing worksheet option, the pivot table appears on the current
worksheet (you can specify the starting cell location).
Figure 9-7: In Step 3, you specify the pivot table’s location.
At this point, you can click the Options button to select some options that
determine how the table appears. (Refer to the sidebar “Pivot Table Options.”) You can
set these options at any time after you create the pivot table, so you do not need to
do so before creating the pivot table.
You can set up the actual layout of the pivot table by using either of two
techniques:
Search JabSto ::




Custom Search