Shewhart x-bar 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 x-bar 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 x-bar chart starting with the raw data, but this would require the extra step of calculating the summary statistics.
  1. Launch Excel.

  2. Enter the values to be plotted.

    Screenshot: screenshot

  3. Create the x-bar chart.

    Excel generates the chart and places it in Sheet1.

    Screenshot: screenshot

  4. Adjust the chart for better display.

    Screenshot: screenshot