Run Chart in Excel

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. It analyzes the data and identifies unstable points and trends.

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

If you have created a Run Chart, and would like to see it is a Control Chart, 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:

run-chart-to-control-chart

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

QI Macros installs a new tab our 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.

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


Why Choose QI Macros for Excel

affordable

Affordable

  • 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