Fixed Limit Control Charts
It's Easy to Fix Limits in QI Macros Control Charts
There are four ways to fix limits in QI Macros:
- QI Macros Fixed Limit Control Chart
- Control Charts Created with a Macro
- Using the Chart Menu
- Control Charts Created Using Control Chart Templates
Control Charts Created with a Macro
When you run a control chart, the data you select is the baseline data. It fixes the limits. When you add data to an existing chart, the limits stay the same.
- Select the baseline data and run a control chart.
- Copy/Paste any additional data to the control chart worksheet.
- Click on the chart and then click on the QI Macros chart menu. To access the menu, look to the far right under Chart Tools.
- After you click on QI Macros Chart, the control chart tools menu will show up on the far left. Next select "Add Data."
- Input the number of rows of data you just added to the intermediate spreadsheet and click OK. This function will change the "source data range" of the chart and will update the chart to display your new data.
- Next rerun stability analysis on the chart. Click on the chart sheet. Use QI Macros menu to select "Analyze Stability". QI Macros will rerun stability analysis on your old and new data.
Use QI Macros Chart Menu to Fix Limits
If you want to fix the control limits on an existing chart:
- Click on the point after the baseline data and use "Fix Limits" from QI Macros Chart Menu:
- The macros will fix the control limits using the data before the selected point.
-
Don't forget to rerun stability analysis using the new control limits.

Fixed Limit Control Charts Created with a Template
Control Chart templates include a Fixed Limit Control Chart Worksheet:
- Enter your data in the cells.
- Set the limits as shown above. The default is the normal formulas for the type of chart. Just type in your limits.
- Re-run stability analysis.
Why Choose QI Macros Over Other Control Chart Software?
Affordable
- Only $279 USD - less with quantity discounts
- No annual subscription fees
- Free technical support
Easy to Use
- Works right in Excel
- Create a chart in seconds
- Easy to customize & share charts
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free