Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 12 Quality Control 515

Figure 12-19
The Create a
Pareto Chart
dialog box

7 Click OK.

Excel generates the chart shown in Figure 12-20.

3 Click the Data Values button and then select the range names from

Head 01 to Head 24 in the range names list (do not select the Time

variable). Click OK.

4 Click the Data values represent drop-down list box and select Error

occurs with a value less than.

5 Type 368.6 in the text box below the drop-down list box.

6 Click the Output button and direct the output to a new chart sheet

named Pareto Chart. Click OK.

Figure 12-19 shows the completed dialog box.