Recalculate UCL and LCL on Control Charts
Recalculate Control Limits on Charts Created with a Macro
- 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":
- The macros will re-calculate the control limits using all of the data points.
-
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?
Fast and Easy to Use
- Works right in Excel
- Create charts in seconds
- Easy to customize & share charts
- Free Training Anytime
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free
Affordable
- Only $349 USD
Quantity Discounts Available - No annual subscription fees
- Free technical support