Datasheet

Click Next to go to the second step of the wizard. You’ll see, as shown in Figure 1-10, that
the range you selected earlier, A4:C28, is already entered in the Range field. This illus-
trates how you can select your data range before starting the PivotTable Wizard, as you
have done here, or select it from the wizard, as you did in the earlier example. The results
are the same either way.
Figure 1-10: If you select the data range before starting the PivotTable Wizard the range will be
entered automatically.
Click Next to proceed to the third wizard step. For this example leave the default New
Worksheet option selected and then click Finish. You’ll see the blank PivotTable created in
a new worksheet, as shown in Figure 1-11.
Figure 1-11: The blank PivotTable is created on a new worksheet.
Part I: Understanding PivotTables and Charts
10
03_772402 ch01.qxd 11/30/05 9:41 PM Page 10