Run Chart in Excel

Create a run chart in seconds using QI Macros add-in

Run Charts Consist of a Line Graph and Center Line

The center line is calculated from the data and can represent either the average or median. Run charts are an improvement over the ancient line graph. But they aren't cutting edge or state of the art like control charts.

Run Charts vs Control Charts

Run Chart

run chart excel

A run chart adds a center line which represents the average or the median of the data.

Control Chart

control chart excel

A control chart is a smart chart. It calculates a center line and sigma lines and analyzes the data to identify unstable points and trends.

Control Charts are Just as Easy to Create as Run Charts Using QI Macros Add-in for Excel

QI Macros installs a new tab on your Excel menu. Just select your data and select Run Charts from QI Macros menu. Then choose whether you want the center line to be the average or median of your data. Or select the Control Chart wizard and draw a control chart to perform a more complete analysis on your data.

run chart menu

QI Macros also includes a run chart template.

Convert Your Run Chart into a Control Chart in One Easy Step!

If you have created a Run Chart using QI Macros, you can easily convert it to a Control Chart. Just select your chart, then from the "QIMacros Chart" menu, choose the "Show/Hide Sigma Lines" drop-down. There, you can choose which Sigma Lines to include on your chart.

Note: 3 Sigma represents the Upper and Lower Control Limits:


You won't believe how easy it is! Watch QI Macros in action:

Why Choose QI Macros for Excel



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