Define the Data Points Used to Calculate Control Chart Limits

It's Easy to Set or Fix Limits in QI Macros Control Charts

When you create a control chart using QI Macros, the data you select is the baseline data. It is used to calculate the control limits. If you selected 20 points, 20 points are used. If you selected 14 points, then 14 points are used and so on. When you add data to an existing chart, the limits stay the same.

If you want to change the data points used to calculate the control limits after you have added new data:

  • use Recalculate UCL /LCL to use ALL of the data points.
  • use Fix Control Limits to use a subset of the data points.

Here's how to use the Fix Control Limits option:

  1. Click on the point just to the right of the points you want to include in the fixed control limit calculations.

    Select Point after Fixed Limit data
  2. Click on QI Macros Chart Menu and then Change UCL/LCL - Fix Control Limits:

    Fix Control Limits with QI Macros
  3. QI Macros will use the points to the left of the selected point to calculate the fixed control limits:

  4. Don't forget to rerun stability analysis using the new control limits.

Learn More...

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