QI Macros Control Charts

Show Process Change on Control Chart Templates

It's easy to show process changes on a control chart created by QI Macros. The process is different depending on how you create your control chart. This page covers control chart templates. See these pages for other options:

Control Chart Templates

  1. Look for the box to the right of the control chart marked Process Change at Row:

    control chart template with process change
  2. Input the row in the Excel spreadsheet where the process change occurred.

    process change input box

  3. The template will calculate a new set of control limits starting at the data point in the row you entered. On the X chart templates the process change will be reflected on both the X and R charts.
  4. Don't forget to rerun stability analysis using the new control limits. Click on the chart sheet. Use the QI Macros menu to select "Analyze Stability."Note: This step needs to be performed separately for the X and R charts.


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