Datasheet

In this dialog box you specify where to place the PivotTable. You can also specify the table

layout and set some options using the Layout and Options buttons, but that’s a topic for a

future part. For now just select the Existing Worksheet option and enter the address of a

cell that is a few rows below the data, such as A28. Then click Finish to create the

PivotTable report. Your screen will look like Figure 1-5.

Figure 1-5: The newly created PivotTable report waiting to be customized.

Your screen displays three elements, as shown in the figure:

• The PivotTable itself, which is currently empty.

• The PivotTable toolbar, which provides buttons for commonly used PivotTable tasks and

commands.

• The PivotTable Field List, which lists the data fields (columns) that are present in the

raw data.

You will be learning all the details of these various elements in future parts. For now just

follow the steps required to create the PivotTable report. This requires that you select the

data items you want in the report and drag them from the PivotTable Field List to the

appropriate location in the PivotTable report:

1. Drag the Region field from the PivotTable Field List and drop it in the Drop Row Fields

Here section of the PivotTable.

2. Drag the Camping field from the PivotTable Field List and drop it in the Drop Data Items

Here section of the PivotTable.

That’s it; your PivotTable report is done and will appear as shown in Figure 1-6. The only

remaining step is to format the numbers to display as currency by selecting the cells and

clicking the Currency Style button on Excel’s Formatting toolbar. You may also need to

increase the width of Column B to display the data correctly.

Tip 3: Creating a PivotTable Report

Part I

03_772402 ch01.qxd 11/30/05 9:41 PM Page 7