Microsoft Office Tutorials and References
In Depth Information
Creating Charts from PivotTables Using PivotCharts
If necessary, restore your PivotTable to the appearance shown in Figure
8–61, in which Salesperson occupies the Row Labels area and Order
Amount is in the Values area.
Then click anywhere in the PivotTable, click the PivotTable Tools Options
tab, and choose PivotChart from the Tools button group. You’ll see the
familiar dialog box shown in Figure 8–62.
Figure 8–62. The Insert Chart dialog box, again
Note that you’ve already seen this box in Chapter 6. Go ahead and click
OK to Excel’s default selection, that redoubtable Column chart, and
you’ll see the data presented as in Figure 8–63.