Control Chart Template with Center Line Based on Average

The QI Macros default control chart template uses the average of your data to calculate the center line on your control chart. The 1 and 2 sigma lines and the upper and lower control limits are derived from this average.

To use the control chart template:

  1. Click on the QI Macros menu and select Fill in the Blank Templates then SPC Charts.
  2. Click on one of the control chart templates to open it (e.g. XmR, XbarR, XbarS, Levey Jennings.)
  3. The control chart using the average line is the default and is usually the worksheet that is the farthest tab to the left (e.g. XmR Individuals Chart.)
    control chart template options
  4. Data input areas are shaded in yellow. As you input data, the charts populate to the right.
  5. To the right of the control charts is a box labeled "Process Change at Row." If you want to show a process change on your chart, simply input the row where you want the change to occur. The template will calculate two sets of control limits. The first uses the data points up to the row you input and the second uses the data in the row you input and all points after it.
  6. Additionally, the X chart templates have input areas to define spec limits for the histogram.
Purchase QI Macros SPC Software for Excel through our secure shopping cart or try a free, QI Macros 30-day trial!