Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 7 Tables 283

To view the counts of the responses again:

1 Right-click any of the percentages in the PivotTable and then click

Value Field Settings from the pop-up menu.

2 Click the Show values as tab, select Normal from the Show values

as list box, and click the OK button.

Displaying Categorical Data in a Bar Chart

You can quickly display your PivotTable data in a PivotChart. The default

PivotChart is a bar chart, in which the length of the bar is proportional to

the number of counts in each cell.

To create a bar chart for department category:

1 With the PivotTable still selected, click the PivotTable button

located in the Tools group of the Options tab on the PivotTable Tools

ribbon.

2 Select the fi rst column chart from the Insert Chart dialog box and

click the OK button.

As shown in Figure 7-8, Excel adds a column chart to the worksheet

displaying the department counts from the PivotTable.