2. Name the new macroMakePivotTable.
3. Put the cursor anywhere inside the sales data.
4. Choose Insert Ribbon ?¤Tables ?¤ PivotTable. The Create PivotTable dialog box will be
displayed, as shown in Figure 6-2.
Figure 6-2. Create PivotTable dialog box
CHAPTER 6 n PIVOTTABLES 224
The Create PivotTable dialog box contains two sections. The first section is where you can
choose a data source. This can be a table or range within an Excel workbook or data from an
external source. External data is accessed through a connection file, such as an Office Data
Connection (ODC) file (.odc) or a Universal Data Connection (UDC) file (.udcx).
The second section lets you dictate where you would like the PivotTable report to be
placed.
5. For now, just accept the defaults and click OK. A blank PivotTable report will be
inserted on Sheet4, as shown in Figure 6-3.
Figure 6-3. Excel 2007 PivotTable report default view
The new PivotTable report has a revamped interface that allows for easy manipulation of
pivot data. All fields in the table are listed in the PivotTable Field List pane, which you can see
on the right side of Figure 6-3. Check boxes are provided for users to choose the fields they
want to include in the report. Text fields will by default place themselves in the Row Labels list
and numeric fields will default to the Values list.
An easier way to create a report is to drag the field from the selection section at the top of
the PivotTable Field List pane to the correct list below (shown in Figure 6-4).
Pages:
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221