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 excel template

How to Use QI Macros Pre Control Chart Template in Excel

  1. QI Macros installs a new tab on Excel's menu.
    QI Macros Add-in for Excel
  2. Click on QI Macros menu tab and select Control Chart Templates, then Pre-control chart to open a template.
  3. Enter the upper and lower specification limits into the data sheet at H1 and J1.
    input spec limits into pre-control chart
  4. Add data as you begin to run the process.
  5. 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.

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 Pre Control Chart Template for XbarR data with up to five samples.

Pre Control Chart for X bar R data

Why Choose QI Macros Over Other Control Chart Software?



  • Only $279 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

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