Microsoft Office Tutorials and References
In Depth Information
Selecting a row to plot
If the data consists of numerical values, you may want to create groups. To do so,
right-click the field button in the pivot table and choose Group. Then specify the
parameters for the grouping. Figure 9-21 shows a frequency distribution for numeric
data, with the results grouped. Note that the pivot table displays a count of the
values. By default, the pivot table will display the sum. You’ll need to change this.
Figure 9-21: This pivot chart displays a frequency distribution for the
data in column B, in groups of five.
Selecting a row to plot
Although pivot tables are often used to summarize large data sets, they can also be
useful for small amounts of data. Figure 9-22 shows a range of data (in range
A3:D17), with a pivot table and a pivot chart. The pivot table (and the pivot chart)
contains a Page field (Year), and three Data fields (CA, WA, and Other).
To create this pivot chart:
1. Select any cell within the data range.
2. Start the PivotTable and PivotChart Wizard, and choose the option to
create a pivot table and a pivot chart.
3. In Step 3, click the Layout button.
4. Drag the Year button to the Page field.
5. Drag the other three buttons (CA, WA, and Other State) to the Data area.
6. Click Finish to create the pivot table and the pivot chart.
After creating this chart, you can quickly change the year displayed in the chart
by using the Year field button.
Search JabSto ::




Custom Search