Microsoft Office Tutorials and References
In Depth Information
Chapter 9: Using Pivot Charts
Using Pivot Charts
IN THIS CHAPTER
An introduction to pivot tables
Pivot table terminology
How to create a pivot table
How to create a pivot chart
Differences between pivot charts and standard charts
How to unlink a pivot chart from a pivot table
How to create a standard chart from pivot table data
M ANY PEOPLE ( AUTHOR INCLUDED ) consider pivot tables to be the most innovative
and powerful analytical feature in Excel. A pivot table can instantly convert a mass
of data into a nicely summarized table. Pivot tables have been around since Excel 5.
Beginning with Excel 2000, this feature was augmented to include charting
If you’re using Excel 97 or earlier, much of the information in this chapter
does not apply.
This chapter starts out with an introductory overview of pivot tables and then
moves on to cover pivot charts.
What Is a Pivot Table?
A pivot table is essentially a dynamic summary report generated from a database.
The database can reside in a worksheet or in an external file.
A pivot table can create frequency distributions and cross-tabulations of several
different data dimensions. In addition, you can display subtotals and any level of
detail that you want. Perhaps the most innovative aspect of a pivot table is its