Microsoft Office Tutorials and References
In Depth Information
Figure 8–62. Just a handy right-click away
It’s a pretty short trip from pivot reports to their more showy neighbors, pivot charts, and the trip is a
pretty easy one to take. And once your pivot chart beaches up on the worksheet, you can call upon most
of the same charting options we described in the charting chapter. As we’ll see, however, pivot charts
work slightly differently from the conventional chart types.
You can compose a pivot chart in one of two ways, either by grabbing the data from an existing
pivot report and routing them to a chart, or by designing a chart from scratch via PivotTable commands
(but if you opt for the latter, you should ask yourself whether you need to work with PivotTables at all,
rather than Excel’s standard charting tools).
Let’s give one a try, applying the first method to a simple pivot report.
Click anywhere in the source data and click Insert Pi v otT a bl e OK.
Then click Salesperson and Order Amount on the PivotTable Field List, and
you wind up with this familiar scenario (Figure 8–63):
Figure 8–63. We’ll start charting with these pivot data