Control Chart Template in Excel

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 an easy way to create control charts in Excel?

• Do you have production line staff who don't have time to learn a complicated SPC Software package?
• Do you need an easy to use fill-in-the-blanks solution that anyone can use?

The QI Macros contain easy to use fill-in-the-blank control chart templates that work right in Microsoft Excel. Templates include:

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 attribute and variable control chart templates are actually made up of several worksheets. See the links at the bottom of this page for detail about each type of template.



4. Click on any of the worksheets and input your data into the yellow input area.



5. As you input data, the charts populate to the right. Depending on the template, there are yellow input areas to the right of the control charts for additional functionality like defining spec limits for the histogram, showing a process change, defining how many points you want the chart to roll, etc.

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 (DNOM) 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!