Microsoft Office Tutorials and References
In Depth Information
Creating Pivot Charts
Count to show the count of the records for a particular category (Count
is the default setting for any text fields that you use as Data Items in a
pivot table)
Average to calculate the average (that is, the arithmetic mean) for the
values in the field for the current category and page filter
Max to display the largest numeric value in that field for the current
category and page filter
Min to display the smallest numeric value in that field for the current
category and page filter
Product to display the product of the numeric values in that field for the
current category and page filter (all non-numeric entries are ignored)
Count Numbers to display the number of numeric values in that field
for the current category and page filter (all non-numeric entries are
ignored)
StdDev to display the standard deviation for the sample in that field for
the current category and page filter
StdDevp to display the standard deviation for the population in that
field for the current category and page filter
Var to display the variance for the sample in that field for the current
category and page filter
Varp to display the variance for the population in that field for the
current category and page filter
After you select the new summary function to use in the Summarize Value
Field By list box on the Summarize Values By tab of the Value Field Settings
dialog box, click OK to have Excel apply the new function to the data present
in the body of the pivot table.
Creating Pivot Charts
After creating a pivot table, you can create a pivot chart to display its
summary values graphically in two simple steps:
1. Click the PivotChart command button in the Tools group on the
Analyze tab under the PivotTable Tools contextual tab to open the
Insert Chart dialog box.
Remember that the PivotTable Tools contextual tab with its two tabs —
Analyze and Design — automatically appears whenever you click any
cell in an existing pivot table.
2. Click the thumbnail of the type of chart you want to create in the
Insert Chart dialog box and then click OK.
Search JabSto ::




Custom Search