Shewhart xbar Charting in Microsoft^{®} Excel
Chapter 7, Example 9
Note: Because Excel's data analysis tools have no builtin control chart tools, this example shows how to create an xbar chart from the summary statistics given in Table 7.17 (p. 503) and the standard values for the mean and standard deviation using Excel's Chart feature. If necessary, it would be possible to create an xbar chart starting with the raw data, but this would require the extra step of calculating the summary statistics.
 Launch Excel.
 Enter the values to be plotted.
 In cell A1, type "xbar"
 In cell B1, type "Center Line"
 In cell C1, type "LCL"
 In cell D1, type "UCL"
 In cells A2A23, enter the sample means from the xbar column of Table 7.17 (p. 503).
 In cells B2B23, enter "10"
 In cell C2, enter "=103*1.9/SQRT(5)"
 Select cells C2C23.
 Select "Edit > Fill > Down."
 In cell D2, enter "=10+3*1.9/SQRT(5)"
 Select cells D2D23.
 Select "Edit > Fill > Down."
Screenshot:
 Create the xbar chart.
 Select "Insert > Chart."
 In the dialog box that follows, select "Line" from the "Chart type" list; then, under "Chart subtype, select the subtype whose label reads, "Line with markers displayed at each data value."
Screenshot:
 Click "Next."
 Fill out the "Data Range" pane of the next window as follows:
Input Type 
Label 
Value 

Data range: 
=Sheet1!$A$1:$D$23 

Columns 
selected 
Screenshot:
 Click "Next."
 Fill out the "Titles" pane of the next window as follows:
Input Type 
Label 
Value 

Chart title: 


Category (X) axis: 
Sample 

Value (Y) axis: 
xbar 
Screenshot:
 Click the "Gridlines" tab.
 Make sure all checkboxes in the "Gridlines" pane are unchecked.
Screenshot:
 Click "Next."
 Fill out the resulting dialog box as follows:
Input Type 
Label 
Value 

As object in: 
selected 

As object in: 
Sheet1 
Screenshot:
 Click "Finish."
Excel generates the chart and places it in Sheet1.
Screenshot:
 Adjust the chart for better display.
Screenshot: