Datasheet

So far this looks like the step you took when you created the PivotTable in the previous
example, except that the Field List contains different field names. The differences come in
the next steps and are the result of the way the raw data are arranged. Here’s what to do:
1. Drag the Store field from the Field List and drop it in the section of the PivotTable
labeled Drop Row Fields Here.
2. Drag the Category field from the Field List and drop it in the section of the PivotTable
labeled Drop Column Fields Here.
3. Drag the Titles field from the Field List and drop it in the section of the PivotTable
labeled Drop Data Items Here.
The PivotTable that will result from these steps is shown in Figure 1-12.
Figure 1-12: Excel automatically calculates and displays totals for each category and for each
store, as well as an overall total.
Now you can go ahead and create a PivotChart based on this PivotTable report. Make sure
the PivotTable is active; then click the Chart Wizard button on the PivotTable toolbar. The
resulting chart is shown in Figure 1-13. Each store is represented by a bar in the chart,
and within each bar the different categories are differentiated by color.
The Category button above the chart legend and the Store button below the horizontal axis
both have drop-down arrows on them. Click an arrow to display a list of fields to include in
the chart, as shown in Figure 1-14. (This works the same way as the drop-down lists in the
PivotTable itself, which you saw earlier in this part.) Selecting fields to display in the chart
affects the PivotTable report too. In other words, the PivotTable report and the PivotChart
are linked and always display the same data.
Tip 4: Creating a PivotTable Report with Multiple Columns
Part I
11
03_772402 ch01.qxd 11/30/05 9:41 PM Page 11