Control Chart Template for Horizontal Data in Rows

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

Most of the QI Macros control chart templates assume your data is organized in columns. Use the horizontal worksheet if your data is organized in rows.

To use this control chart template:

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. Click on the worksheet tab titled horizontal (e.g. XmR Horizontal.)



4. Data input areas are shaded in yellow. As you input data, the charts below plot your data.



5. To the right of the control charts is a yellow input cell labeled "Process Change at Row." If you want to show a process change on your chart, simply input the row in column B where you want the change to occur. The template will calculate two sets of control limits. The first uses the data points up to the row you input and the second uses the data in the row you input and all points after it.



6. Additionaly, the X chart templates have input areas to define spec limits for the histogram.

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 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!