Trying to Create Hotelling T2 Charts in Excel?

QI Macros can create them for you!

Create an Hotelling T2 Chart using QI Macros:

  1. Select your data.
  2. Click on QI Macros menu > Control Charts (SPC) > Special> Hotelling T2.
  3. QI Macros will do the math and draw the chart for you.
  4. QI Macros will also turn any unstable points or conditions red.

Go Deeper: Hotelling Chart Evaluates Two Interacting Measurements Simultaneously.

Similar to the XmR Chart, the Hotelling T2 Chart evaluates the covariances of the ranges between each of the two measures and the covariances of the actual data points. This gives two charts that are similar to the average and Range in the XmR.

Imagine for a moment that you are measuring the location of a hole drilled in a sheet of metal. It could be left or right, up or down. It's possible that both measurements, taken separately, could be stable and predictable, but the two together could have outliers.

To run a hotelling chart in QI Macros, select two columns of data and then select Hotelling T2 Chart from the Control Charts (SPC) > Special (CUSUM, EWMA) menu. QI Macros will create two charts:

Hotelling T2 control chart

Hotelling Chart Template in QI Macros for Excel:

Find the Hotelling Chart template by clicking on the QI Macros menu > Control Chart Templates > Special (CUSUM, EWMA) > Hotelling Chart:


Stop Struggling with Hotelling T2 Charts!
Start creating your Hotelling T2 Charts in just minutes.

Download a free 30-day trial. Get Hotelling T2 Charts now!

Why Choose QI Macros Over Other Control Chart Software?

easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free



  • Only $349 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support