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

How to Use the 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 the 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.
  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 $249 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

  • 100,000 users in 80 countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus free