QI Charts

QI Charts is a control chart add-in for Microsoft Excel. The control chart (also known as a Shewhart chart) is a statistical tool used to distinguish between variation in a measure due to common causes and variation due to special causes.

This name is misleading since the most common uses of these charts in improvement activities are to learn about variation and to evaluate the impact of changes. A more descriptive name might be "learning charts" or "system performance charts."

QI Charts software allows you to create control charts using data that you have compiled in Microsoft Excel. QI-Charts requires that your data be column-oriented. The first column, the index, contains values that will appear on the X-axis of the control chart. These may be dates or times, labels, or a numbered series.

Creating a control chart in the same workbook as your data is made simple with a wizard dialog prompting you for data ranges, values, and phase boundaries. QI-Charts places the new control chart just to the right of your data range. You can make adjustments to your control chart using Excel's regular chart menus.

QI charts can be used to create the following types of charts:

  • Run Chart with median
  • Charts for attributes data
    • C Chart
    • P Chart
    • U Chart
    • P' Chart (corrects for large denominators)
    • U' Chart (corrects for large denominators)
  • Charts for variables data
    • XS Chart
    • Individuals Chart
  • Charts for events and time between events
    • G Chart
    • T Chart

Download the QI charts User Manual

Notes:

  • Windows operating system with Excel is required to run QICharts. QI Charts is not compatible with a Mac.
  • Microsoft Windows 7 and Vista require you to turn off "User control" before loading program. See guide for details.

Attention Users: Provide Feedback Here


Pricing

  • Single License - $69
  • Site license (single location) - $500
  • Small company license (less than 500 employees) - $800
  • Large company license (more than 500 employees) - $1200

QI Charts is available for purchase and download through our site. To purchase QI charts:

  • Complete registration form
  • Add QI Charts to your shopping cart, and complete checkout process.
  • You will receive and email with instructions about how to download and install QI charts after your payment has been processed.
  • QI Charts will work on versions of Excel 2003 or later.

Example Wizard Screen


Example Control Chart


Example Data Table


© 2009 Process Improvement Products