X bar R Chart Template for Excel

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Copyright © 2009

The purpose of the X bar r chart template is to evaluate the stability of processes using variable data--time, cost, length, weight.

Here is an example of the X bar r chart template in the QI Macros for Excel. Just type data into the yellow input area and the control charts, histogram and probability plot will be drawn to the right. You can also cut and paste data from another spreadsheet into the template.

The X bar R chart can help you evaluate the cycle time for almost any process: making a widget, answering a customer call, seating a customer, delivering a pizza, or servicing an appliance. This chart is especially useful when you do this many times a day. Collecting the data could be expensive if you measured every time you did it. Using a small sample (typically five), however, you can effectively measure and evaluate the process.

Calculate, plot, and evaluate the range chart first. If it is "out of control," so is the process. If the range chart looks okay, then calculate, plot, and evaluate the X chart.

The X bar R chart template is actually made up of several templates depending on your needs:

Just click on the appropriate worksheet tab to access any of these options:

• Center Line Based on Average (far left tab)
• Templates to Handle Rolling Data
• Center Line Based on Median
• Short Run Control Charts
• Templates for Horizontal Data
• Control Chart with Fixed or Historical Control Limits

Other Resources

• X bar R chart
• Video showing how to create an X bar R chart in Excel
• X bar R chart formulas
• X bar S chart

The XbarR chart template is just one of the tools included in the QI Macros for Excel SPC Software for Excel.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Try QI Macros
FREE
For 30-Days

Or Buy It Now!

Unconditional
90-Day
Money-Back
Guarantee