Data Analysis with Microsoft Excel: Updated for Office 2007

418 Statistical Methods

Next you can create a line chart based on the values in the PivotTable.

To create a line chart of the cell average:

1 Click the PivotChart button from the Tools group on the Options tab

of the PivotTable Tools ribbon.

2 Click Line from the list of chart types.

3 Click the fi rst chart sub type in the list and click OK.

Excel creates the PivotChart of the PivotTable data as a line chart.

4 With the PivotChart selected, click the Move Chart button from the

Location group on the Design tab of the PivotChart Tools ribbon and

move the chart to a new chart sheet named Interaction Plot.

Figure 10-18 displays the chart.

Figure 10-18

Interaction

plot of

cola type

versus cola

brand

The plot shows that the foam volumes of diet and regular colas are very

close, except for Coke. If there is no interaction between cola brand and

cola type, the difference in foam volume for diet and regular should be the

same for each cola brand. This means that the lines would move in parallel,

always with the same vertical distance. Of course, there is a certain amount

of random variation, so the lines will usually not be perfectly parallel. The