Control Chart Construction
Key Components of a Control Chart
- LCL (Lower Control Limit): 1.5
- Centreline: 8
- UCL (Upper Control Limit): 15
Steps to Construct a Control Chart
-
Prepare the Data
- Gather data for the specific statistic that needs monitoring.
- Assume the control limits (LCL, Centreline, UCL) are already defined.
-
Highlight Control Limit Values
- Highlight the control limit values in your dataset.
- Drag down to apply these values across your data range.
-
Create the Line Chart
- Highlight the entire dataset.
- Go to the
INSERT
menu.
- Select
Line Chart
.
- Choose the first template option available.
- This will create a basic control chart.
-
Add Markers to the Chart
- Right-click on the blue line within the line chart.
- Select
Format Data Series
.
- Click on the
bucket icon
(formatting options).
- Go to
MARKER
, then MARKER OPTIONS
.
- Select
Automatic
to add markers.
Conclusion
- Following these steps will result in a completed control chart.
- The process involves setting up your data correctly and using Excel's charting tools to visualize the control limits and the data.
Note: This process is demonstrated visually in the accompanying presentation/video.