Microsoft Office Tutorials and References
In Depth Information
Creating Charts from PivotTables Using PivotCharts
Figure 8–63. A PivotChart. Note the difference from a standard Excel chart: the appearance of what are called
It isn’t a thing of beauty yet, but the chart has captured the PivotTable data. The chart
takes the salesperson names (the data in the Row Label), applies them to the horizontal
(category) axis, and draws its vertical (value) axis from the sales figures.
NOTE: When you click in a PivotChart, the Row Values area in the PivotTable Field List is named
Axis Fields (Categories). Click back in the PivotTable, and the Row Values label is restored.
And once the PivotChart makes its appearance in the worksheet, the means for
modifying and reformatting it are nearly identical to the options described in Chapter 6.
When you click in the chart, a PivotChart Tools contextual tab is ushered onto the screen,
offering some familiar selections (see Figure 8–64).
Figure 8–64. PivotChart options available via the PivotChart Tools contextual tab: The Design, Layout, Format, and