Before Excel 2007 (the current version of Excel), you used the PivotTable and PivotChart Wizard to create PivotTables. Even though Excel 2007 provides a new and simpler way to create PivotTable, as described in the previous sections, the PivotTable and PivotChart Wizard is still available. Some people may prefer the wizard, particularly those who have experience with it. For this reason, I have included it in this book. However, if you are happy with the new techniques for creating a PivotTable, you can ignore these sections. If you want to work along with this walk-through, open the file SportingGoodsRawData. This worksheet contains data for a sporting goods chain and gives customer count and sales in various categories for three stores over a week. It is shown in Figure 1-10. Make sure the cell pointer is on a cell in the table, and then press Alt+D followed by P to open the PivotTable and PivotChart Wizard. Figure 1-11 shows the first step of the wizard. In this dialog box, make sure that the options are selected as shown in Figure 1-11:
Then click the Next button to move to Step 2 of the wizard, shown in Figure 1-12. Here you specify the range where the data is located. If you placed the cell pointer in the table before starting the wizard, Excel will automatically select the range for you, A2:K44 in this example, as shown in Figure 1-11. Otherwise you can type the range into the Range box or select it with the mouse as follows:
When you have the data range entered, click the Next button to move to the third and final step of the wizard, shown in Figure 1-13. In this dialog box you specify where to place the PivotTable, either on a new worksheet or an existing worksheet. 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 chapter. For now, just select the
New Worksheet option, and then click Finish to create the PivotTable report (see Figure 1-14).
Notice that the screen in Figure 1-14 looks identical to the one in Figure 1-3. That’s right—if you use the PivotTable and PivotChart Wizard to create a PivotTable, the result is just the same as if you had used the newer tools in Excel 2007. You then follow the same steps to define the PivotTable columns and rows or to create a multi-column report, as described in the previous two sections.
