Real Time SPC Template for Excel

XbarR chart Six Pack performs analysis as data is imported

This Real Time SPC template for Excel, parses your data into subgroups and automatically performs statistical analysis. It creates control charts, histograms and calculates Cp and Cpk.

To use this template:

  1. Click on the QI Macros menu and select Control Chart templates and then XbarR Six Pack.
  2. Select the tab labeled XbarR Realtime.
  3. Click on Cell A1 and enter the number of samples per subgroup. If you have a USL and LSL, enter it in cells AM3 and AM5.
  4. Clear contents of cells B2:B21
  5. Click on Cell B2 and start entering data. You can type this manually or use a gage interface (USB or RS232)
    real time control chart template
  6. As you add new data your charts and calculations will update automatically.
  7. You can add more rows by copying cells C21:L21 down to row 22 and beyond.

real time spc template for excel

Learn more about control chart template options.

Why Choose QI Macros Over Other Control Chart Software?



  • 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