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":

    qi-macros-process-change-menu
  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 and then, from the QIMacros Chart menu, select "Analyze Stability." QI Macros will re-run stability analysis using the new control limits.


Recalculate Control Limits on Charts Created with a Template

If your control chart template includes more than 50 rows of data, click on the chart, click on the QIMacros Chart menu > Process Changes, and then select "Recalculate UCL/LCL":

qi-macros-process-change-menu

The Recalculate UCL/LCL tool will update the limits calculations found within your template to now include the entirety of your data set.

NOTE: If you do not select "Recalculate UCL/LCL", and your data set includes more than 50 rows of data, your limits calculations will only include the first 50 rows of data.

Don't forget to rerun stability analysis using the new control limits. Click on the chart sheet and then, from the QIMacros Chart menu, select "Analyze Stability." QI Macros will re-run stability analysis using the new control limits.


Learn More...


Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • 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