Pre Control Chart in Excel

Use a Pre Control Chart When You Don't Have Enough Data Points (20 samples)

Sample Pre Control Chart 

pre-control chart in QI Macros for Excel

How to Create a Pre Control Chart Using QI Macros

  1. Open the pre-control chart template by clicking on QI Macros, SPC Charts, Pre-control chart
  2. Enter the upper and lower specification limits into the data sheet at H1 and J1
  3. Add data as you begin to run the process.
  4. Evaluate the process much like you would a control chart. Most points should land in the green or yellow. Too many in the red: Danger! You may miss customer specifications.

The QI Macros pre-control chart template also has a template tab for XbarR chart data with up to five samples.

Learn More...

To create a Pre Control Chart using QI Macros...
Try It Now!