Welcome!  This video will show you how to
create a quality control chart either a
C chart P chart or X bar or r chart in
itself I will show you how to create a
pie chart using this data I'm using the
Excel templates for unit 10 a control
chart is simply a scatter plot with
horizontal lines drawn in for the upper
and lower control limits and center line
so let's start with a scatter plot
showing the number of samples along the
x axis and the number of defects along
the y axis I will highlight my data
click on the insert tab and then select
a scatter plot I always think it's a
good idea to add chart titles and axis
titles to a graph I'll just slide my
graph down a little in the open space
next I need to draw in my control limits
and center line I will find that what
these are by going to the upper and
lower limit cells I'm looking at about
51% for the upper limit and 22% for the
lower limit my centerline is at about
37%
go to the insert tab again and click on
the illustrations grouping to find
shapes I will select a line I will draw
my upper limit first at about 51 mark
along the y-axis I'm holding down the
shift key as well to make sure it is
perfectly horizontal now this line is
not very visible so I'll change the
weight of this line with a format
options
I will do this also for the lower limit
which should be at about 22% I'll grab a
line and draw it at about 22 on my
y-axis again I will change the weight to
make it more visible lastly I will do
this for the centerline which should be
at about 37% I'll grab a line and draw
it at about 37 on my y-axis for the
center I will change the color as well
as the weight to distinguish it from the
upper and lower limits.  If you have any
questions please contact your instructor.
