Microsoft Office Tutorials and References
In Depth Information
Complete the first two steps of the PivotTable and PivotChart Wizard. If desired,
set options for the pivot table by using the Options button that appears in the third
dialog box of the wizard. Don’t bother with the Layout button, however. Select a
location for the pivot table and choose Finish. Excel displays a pivot table template
similar to the one you see in Figure 9-10. The template provides you with hints
about where to drop various types of fields.
Figure 9-10: Use the PivotTable Field List toolbar to drag and drop fields onto
the pivot table template that Excel displays.
Drag and drop fields from the PivotTable Field List toolbar onto the template. Or
select the field name, choose the location from the drop-down list, and click the
Add To button. Excel continues to update the pivot table as you add or remove
fields. For this reason, you’ll find this method easiest to use if you drag and drop
data items last. In other words, set up the field items and then specify the data to
If you make a mistake, simply drag the field off the template and drop it onto the
worksheet — Excel removes it from the pivot table template. All fields remain on the
PivotTable Field List toolbar, even if you use them.
Figure 9-11 shows the result of this example. Notice that the page field displays as
a drop-down box. You can choose which item in the page field to display by
choosing it from the list. You also can choose an item called All, which displays all
the data.
Search JabSto ::

Custom Search