Pre Control Chart in Excel

Use a Pre Control Chart When You Have Less Than 20 Data Points

QI Macros Add-in for Excel Contains an Easy to Use Pre Control Chart Template

pre control chart template in excel

How to Use QI Macros Pre Control Chart Template in Excel

  1. QI Macros installs a new tab on Excel's menu:
  2. QI Macros Add-in for Excel

  3. Click on QI Macros menu tab, select the Control Chart Templates drop-down, and then choose PreControl Chart to open the template.
  4. Enter the upper and lower specification limits into the data sheet at H1 and J1:
  5. input spec limits into pre-control chart

  6. Add data as you begin to run the process.
  7. 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.
    • Data points in the yellow zones: proceed with caution and potentially readjust your process.
    • Data points in the red zones imply out of control conditions. Stop and reset your process or make corrections.
  8. Red and Yellow Zones are calculated by dividing the Center Line (half of Green Zone) and the Upper and Lower Spec Limits in two.

Tip: Format Y axis: You may need to change the max and min amounts on the Y axis to properly display the areas for each color band. Just right click on the Y axis and select Format Axis then Axis Options.


QI Macros also contains a pre-control chart template for XbarR data with up to five samples

precontrol chart xbar r

Why Choose QI Macros Over Other Control Chart Software?

easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free



  • Only $349 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support