What is a Control Chart?

Control Charts Evaluate Process Performance Over Time

A control chart is essentially a really smart line graph. It performs calculations on your data and displays:

  • the average or median of the data using the center line
  • the amount of variation in data using the control limits.

As data moves through the zones created by these control limits, a control chart highlights data points or trends that should be investigated.

Control Charts Contain These Key Elements

control chart control limits

An Upper Control Limit (UCL) line calculated at 3 sigma above the Center Line.

A line chart of data measuring the process over time.

A Center Line calculated as the average or median of the data.

A Lower Control Limit (LCL) line calculated at 3 sigma below the Center Line.

Think of a control chart as a line graph with built in intelligence that helps you determine what it is telling you.

Three Reasons You Need Software to Create a Control Chart

Control Chart Types

There are seven Shewhart control charts and many more for special situations.

Control Limit Calculations

Each type of control chart has a different formula for calculating control limits.

Stability Analysis Rules

Stability rules identify and highlight points or trends that need to be investigated. They vary by industry.


A 4th reason: control chart software that is affordable and easy to use.

Here is a Control Chart Created Using QI Macros Add-in for Excel

anatomy of a control chart - created by QI Macros for Excel

I purchased QI Macros just to run control charts (worth the price just for that). I had NO idea what a robust product you have developed, and what an amazing bargain I was getting. File me under exceeded customer expectations. 

- Scott Campbell
SwedishAmerican Hospital

Why Choose QI Macros Over Other Control Chart Software?



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

QI Macros Unique Features

Control Chart Wizard

Don't know which control chart to run?
QI Macros does.

Control chart rules are built right into the code.

which control chart do I choose

Tools Menu Automates Common Tasks

Once you create a control chart, its easy to update or customize it using the Control Chart Tools Menu.

  • Show process changes
  • Add target or goal lines
  • Update and change control limit calculations
  • Update stability analysis
  • Customize charts

Easy to Use Templates for Gathering Data

Drop data directly into the yellow input area and the charts automatically update.

control chart templates

Control Chart Dashboards
Great for Regularly Updating Multiple Charts

One input sheet feeds a dashboard of up to 30 charts.

update monthly control charts

Learn More...