Home » Control Charts » Update Charts » Recalculate UCL LCL

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

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...

• Re-analyze Stability with Control Chart Rules
• Show Process Change on Control Chart
• Other QI Macros Control Chart Update Options

---

Why Choose QI Macros Over Other Control Chart Software?