Control Chart Templates with Fixed Control Limits

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

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

Are you looking for a control chart with fixed control limits?

• Do you need to evaluate a batch run against historical control limits.
• Do you need to compare your data against limits established by your customer?

The QI Macros contain control chart templates with fixed control limits. To use these templates:

1. Click on the QI Macros menu and select Fill in the Blank Templates then SPC Charts.

   

2. Click on one of the control chart templates to open it (e.g. XmR Four Pak.)
3. The QI Macros control chart templates are actually made up of several worksheets. Click on the last worksheet labeled fixed (e.g. XmR Fixed.)

   

4. Input your data into the yellow input area.

   

5. To the right of the control charts there are yellow input boxes to define the Upper Control Limit (UCL), the Center Line (CL) and the Lower Control limit (LCL). For X charts you can do this for both the Range chart and the X chart.

Here is a list of the worksheets in the control chart templates with links to more information:

• Control Chart with Center Line based on the Average - uses the average of your data for the center line.
• Control Chart with Rolling Data and Control Limits - graphs the most recent data points as defined by you.
• Control Chart Center Line based on the Median (X charts only) - uses the median of your data for the center line instead of the average.
• Short Run Control Chart - compares your data points against a target value for each point. For use when you are making a few parts of different sizes.
• Horizontal Control Chart worksheet - for data organized in rows versus columns.
• Control Chart with Fixed Control Limits - allows you to enter fixed or historical control limits.

List of control chart templates

Control chart templates are 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

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!