Shewhart R Charting in Microsoft® Excel

Chapter 7, Example 9

Note: Because Excel's data analysis tools have no built-in control chart tools, this example shows how to create an R chart from the summary statistics given in Table 7.17 (p. 503) and the values given for d2 and D2 in Example 9, using Excel's Chart feature. If necessary, it would be possible to create an R chart starting with the raw data, but this would require the extra step of calculating the range for each sample.
  1. Launch Excel.

  2. Enter the values to be plotted.

    Screenshot: screenshot

  3. Create the R chart.

    Excel generates the chart and places it in Sheet1.

    Screenshot: screenshot

    Note: This example has listed only the steps needed to generate a very crude control chart in Excel; the chart will most likely need to be adjusted for aesthetics and readability. Most notably, the markers on the center and control limit lines are confusing and should be removed. Chart elements in Excel are easily edited by double-clicking the element and making customizations in the resulting dialog box. For more help, see where some of these steps are detailed in step 4.