XbarS Chart Six Pack Template for Excel

Same as Minitab's Capability Sixpack™ for a fraction of the cost

You don't have to spend alot of money on expensive software to perform process stability and capability analysis on your data.

QI Macros Add-in for Excel makes SPC as easy as typing data into an Excel spreadsheet.

Open up the XbarS Six Pack by clicking on the QI Macros tab on Excel's menu, then Control Chart Templates then XbarS Six Pack.

Then just type your data into the yellow input area and the control charts, histogram, values plot and probability plot will be drawn to the right. You can also cut and paste data from another spreadsheet into the template:


Sigma Estimator Formula

The X and S Six Pack also lets you choose which formula you want to use for sigma estimator. The default is Pooled Standard Deviation but you can also select Sbar by changing the number in cell AV:2:

sigma estimator options in XbarS template


Tip: QI Macros will prompt you for your subgroup size. A subgroup is a group of measurements produced under the same set of conditions. In the example above the subgroup size is five.

Note: The XbarS Chart template in QI Macros was developed to support a maximum of 50 columns of data.

Learn More...

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