Run Chart Template in Excel

Run charts consist of a graph of your data and an average or median line.

Here is an example of a run chart created using the QI Macros Run Chart Template.

Run Chart Rules

There are rules, similar to control chart stability rules, applied to Run Charts. These rules are built into QI Macros run chart template and can be customized by changing the values in cells T3:T6.

If a rule is violated, the corresponding letter, will be displayed on the top of the chart.

Rule

Description

A
Runs Test (are there enough "runs" for the amount of data?) 
B
Trend of seven points ascending or descending.
C
Eight points on one side of the median.
D
14 points alternating up and down.
E
Seven points with the same value.

If the data violates one or more of these rules, the appropriate letter will appear on the top axis. In this example, there are two few runs (A) and a trend of seven points decreasing (B).

To create a Run Chart Template using QI Macros...
Try It Now!