
Chapter 8 Charting in Excel194
Finally, we modify the title to reflect two plots. At this stage, our chart appears as
shown in Figure 8.16, and is ready for us to use in any report that might need it.
Pivot Charts
In the previous chapter we saw how the PivotTable command in Excel allows us to
summarize large data from different perspectives through a few simple mouse clicks.
Often, you would want to summarize the data in the form of charts. The PivotChart
command allows you to do just that. You can build pivot charts directly from the data
or from the pivot table you construct.
To see how to use PivotChart command, let us go back to ...