Control Chart Templates in Excel

Need an Easy Way to Create Control Charts in Excel?

  • Do you have production line staff who don't have time to learn a complicated SPC Software package?
  • Do you need an easy to use fill-in-the-blanks solution that anyone can use?

QI Macros Installs a tab on Excel's menu.

control chart template menu

Just open a template from QI Macros Menu and get started creating charts. Input cells are shaded in yellow. Type directly into a template, cut and paste or link from another worksheet.

Example of QI Macros XmR Control Chart Template

control chart template in excel

Control Chart Templates Included in QI Macros Add-in

Attribute Control Charts

  • c chart
  • p chart
  • u chart
  • np chart

Variable Control Charts

Specialized Control Charts

Each QI Macros Control Chart Template Has These Additional Features

Each template is an Excel workbook made up of several worksheets with varying options.

control chart template options

Control Limit Calculation Options
Default - center line uses average Median: center line uses median Fixed: control limits defined by user Short Run (DNOM): compares data against a target value Real Time XbarR: parses gage data into subgroups for analysis P for np LE 5: for use with small sample sizes (p chart only)
Template Display Options
Rolling Data: user defines # of points to display on chart Scrolling Data: ability to scroll through large data sets

Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • Only $299 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
Data Mining and Analysis
Download Free QI Macros Trial
Buy QI Macros for Excel Now