Microsoft Office Tutorials and References
In Depth Information
Creating a PivotChart
8 In the PivotTable Field List located in the upper-right corner, click Precinct and drag it
down to the Row Labels quadrant, and repeat the procedure for Party. Excel displays the
PivotTable on the left. Notice that the PivotTable has listed the parties in each precinct.
9 Click and drag Party from the PivotTable Field List to the Values quadrant. Excel displays
the count for each party in each precinct as well as the grand total.
10 Click and drag Age group from the PivotTable Field List to the Row Labels quadrant.
Excel breaks the parties into age groups.
11 Choose File > Save to save your work.
Creating a PivotChart
A PivotChart is a visual representation of a PivotTable. In this exercise, you’ll rearrange the
PivotTable data, and then create a PivotChart to represent that data.
1
In the excel0706_done worksheet, click Precinct in the Row Labels quadrant and drag it
up to the PivotTable Field List. Then click Age group and drag it to the PivotTable Field
List. The PivotTable now shows a list of the parties and a count of each.
2
On the PivotTable Tools tab, click Options, and then in the Tools group, click PivotChart
(
). The Insert Chart dialog box appears.
The Insert Chart dialog box of ers a variety of choices for a PivotChart.
3
Select Pie from the column on the left; select the second chart from the left in the Pie
group called Pie in 3-D, and then click OK.
Excel displays a pie chart depicting the data in the PivotTable, and the PivotChart Tools
appear on the Ribbon.
Search JabSto ::




Custom Search