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.

analyze stability on a control chart 

Learn More...

Why Choose QI Macros Over Other Control Chart Software?



  • Only $279 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