271
Creating Your First Pivot Chart
The summary in Figure 8.3 is remarkable. Even if you count clicking the PivotTable icon
as two clicks, you need only five mouse clicks to summarize the 100,000+ records of data
from Figure 8.1 into the summary chart in Figure 8.3.
Changing the Chart Type and Formatting the Chart
You can use the tools on the Design ribbon to change from a default chart type to almost
any other chart type. (However, you cannot use scatter, XY, or bubble charts as pivot
charts.) To change the chart type, you choose Design, Change Chart Type and select a
chart type from the gallery.
You can use the tools on the Layout ribbon to change elements ...