| This tutorial shows you how to create a simple control chart by adding
average, lower and
upper control limits to an Excel XY trend chart. It is based on the example found in
Trend_Control_Chrt_Basics.XLS.
1. Control Charts
A control chart includes the process data series and three (3) lines
reflecting the data average, lower and upper control limits. to build a control
chart, we need to build a trend chart of the process data then add horizontal
lines to represent the average, lower and upper control limits.
The
Add Horizontal Line module shows us how to add individual horizontal lines. We simply need to follow
this procedure for the average, lower and upper control limits to produce our
control chart.
2. Organizing Control Chart Data
To build our control chart, we need to define the start and end points for
our three lines (average, lower and upper control limits). Some users
add three series next to the process data for average, lower and upper
limit values. This is ok, however it is not necessary because we can
define a straight line by two points. Why add hundreds of points when we only
need two?


The alternative to adding the extra points is to build a simple summary table
that includes start and end dates for the three data series, like the
example to the right. This organization is simpler, cleaner and easier to
understand than the multiple point version above.
When we are dealing with many data series, mixing data with average,
lower and upper limits with the trend data unnecessarily complicates the data
organization.



|