Trying to Create XmR Trend Control Charts in Excel?

QI Macros can create them for you!

Create an XmR Trend Chart by running QI Macros:

  1. Select your data.
  2. Click on QI Macros menu > Control Charts (SPC) > Variable> XmR Trend.
  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.

Use an XmR Trend Control Chart to evaluate stability of processes using trended data - costs (e.g., inflation).

XmR Trend Control Chart created using QI Macros for Excel.

xmr trend chart in excel

The Chart will calculate the fit of the data to the trend:

Useful Fit R² > 0.80
Ryx = 0.991
Slope = 3.649
Sigma = 4.265
Probability = 0.444

  • R² gives the fit of the line to the trend. Greater than 0.80 is a good fit.
  • Ryx is the linear correlation coefficient. Compare to probability for df = n - 2.
  • Slope is the positive or negative slope of the trend
  • Sigma is the estimated standard deviation Rbar/d2
  • Probability is critical value for Ryx. If Ryx > Probability then a statistically significant correlation exists.

Stop Struggling with XmR Trend Charts!
Start creating your XmR Trend Charts in just minutes.

Download a free 30-day trial. Get XmR Trend Charts now!

Learn More...

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