Need a Real Time SPC Template for Excel?

QI Macros has a ready made template for you.

This Real Time SPC template for Excel, parses your data into subgroups and automatically draws control charts, histograms and calculates Cp and Cpk.

real time spc template Excel

Here's how the real time spc template works:

  1. All input areas are shaded in yellow.
    • Cell A1 defines the number of samples per subgroup.
    • Column B is where you input your data (either manually or via a USB or RS 232 gage interface).
    • Input spec limits for your histogram in cells AX1 and AX2
  2. As data is input into column B, it is parsed by subgroup based on the value in cell A1. Here are two examples:
Subgroup size 2
Twenty points parsed into 2 columns

subgroup size 2 example
Subgroup size 5
Twenty points parsed into 5 columns

subgroup size 5 example
  1. As data is input and then parsed by subgroup, the charts are automatically populated to the right.

real time spc charts

This template is part of QI Macros SPC Addin for Excel.

QI Macros adds a new tab to Excel's toolbar. To open the template, click on QI Macros, Control Chart templates > Variable (XmR, XbarR/S) > XbarR Six Pack.

variable control chart templates on menu

The XbarR template has several tabs. Click on XbarR Real time.


Stop Struggling with Real time SPC Charts!
Start creating your Real time SPC Charts in just minutes.

Download a free 30-day trial. Get Real time SPC Charts now!

QI Macros Draws These Charts Too!