Want to Change Control Limit Stages or Phases on a Control Chart?

QI Macros Process Change Wizard Can Show Process Changes for You!

Show Process Changes on Control Charts using
QI Macros:

  1. Click on a Control Chart.
  2. Click on QI Macros Chart menu > Process Change Wizard.
  3. QI Macros find any runs and trends in the data and adjust the chart for you..

Go Deeper:Generally, you calculate control limits using your first 20 to 25 data points and then you use those limits to evaluate the rest of your data. If you have a process change, you should recalculate your control limits beginning with the first point after the process change occurred.

QI Macros makes it easy to show process changes on control charts. The process is different depending on how you create your control chart:

New Charts Created with a Macro

To calculate two or more sets of control limits on new charts simply leave a blank row between the data points where you want the limits to change:

insert a blank row to show a process change

Select the data including the blank row(s) and run the chart. You should get a chart with two or more sets of control limits:

recalculate control limits to show process change

Existing Charts Created with a Macro

When you select data and then run a control chart using QI Macros, QI Macros will use ALL of the data points selected to calculate the center line (ie. average). If you have 14 points it will use 14 points, if you have 26 points it will use 26 points, etc. To check which points are used to calculate your center line, simply move the chart to reveal the calculations behind it. Click on the first cell under the cell labeled "Average". You can determine the data range used by viewing the formula in Excel's formula bar.

In the following example, we clicked on cell H2 and noted that the average is calculated using cells B2 to B26 and C2 to C26.

control chart center line formula

To show a process change on an existing chart.

Show Process Change on Control Chart Tutorial Video

  1. Go to the chart and click on the first data point where the process change occurred.
    select point to recalculate control limits

    Tip: The first time you click on a point, Excel will select the whole line. Click on the point a second time to select just the point. If you have done this correctly, Excel will highlight your point.

  2. Click on QI Macros chart menu, select the "Process Changes" drop-down and choose Show Process Change:

  3. qi-macros-process-change-menu

  4. The macros will calculate a new set of control limits starting at the data point you selected.  Note: you can do this more than once on a chart. The example below shows three separate sets of control limits:

    control limits recalculated more than once

  5. Don't forget to rerun stability analysis using the new control limits. Click on the chart sheet. Use QI Macros menu to select "Analyze Stability With Control Chart Rules." QI Macros will rerun stability analysis using the new control limits.

  6. Note: Performing these steps on an X chart will not update the R/S charts.
  7. For XmR, XbarR, and XbarS charts, only utilize the Show Process Change functionality on the X charts - never on the R or S charts.

Use our Process Change Wizard!

The QI Macros Process Change Wizard will analyze your data and locate potential runs and/or trends.

Want to Create an Interrupted Time Series Using QI Macros? See Instructions Below:

You can create an Interrupted Time Series chart by simply performing a Show Process Change at the end and beginning of your two different series!

To do so, place a blank row in between your two data sets, and create your Control Chart:


Stop Struggling with Process Changes!
Start creating your Process Changes in just minutes.

Download a free 30-day trial. Get Process Changes now!

Why Choose QI Macros Over Other Control Chart Software?

easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free



  • Only $329 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support