Recalculate UCL and LCL on Control Charts

Recalculate Control Limits on Charts Created with a Macro

  1. After adding new data to a control chart, click on the chart and then click on the QI Macros Chart menu > Process Changes and then select "Recalculate UCL/LCL":

  2. The macros will re-calculate the control limits using all of the data points.
  3. Don't forget to rerun stability analysis using the new control limits. Click on the chart sheet. Use QI Macros menu to select "Analyze Stability With Control Chart Rules." QI Macros will rerun stability analysis using the new control limits.

Learn More...

Why Choose QI Macros Over Other Control Chart Software?



  • Only $299 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