Microsoft Office Tutorials and References
In Depth Information
Creating a Pivot Table
A single database table can have any number of data fields and category fields.
When you create a pivot table, you usually want to summarize one or more of the
data fields. Conversely, the values in the category fields appear in the pivot table as
rows, columns, or pages.
Exceptions exist, however, and you may find Excel’s pivot table feature useful even
for databases that don’t contain actual numerical data fields. Figure 9-4, for example,
shows a three-column database that consists only of text data. The pivot table counts
the items in fields rather than sums them. This pivot table cross-tabulates the Month
Born field by the Sex field; the intersecting cells show the count for each combination
of month and gender.
Figure 9-4: This database doesn’t have any numerical fields, but you can
use it to generate a pivot table.
In fact, you can create a pivot table from a database that contains only a single
column of data. See “Creating a quick frequency distribution chart,” later in this
chapter.
Creating a Pivot Table
You create a pivot table by using the PivotTable and PivotChart Wizard. You access
this wizard by choosing Data
PivotTable and PivotChart Report. Then, carry out
the steps outlined in the following sections.
This discussion assumes that you use Excel 2000 or later. The procedure
differs slightly in earlier versions of Excel.
Search JabSto ::




Custom Search