# spc chart excel template

still often create control charts in excel. the control chart template on this page is designed as an educational tool to help you see what equations are involved in setting control limits for a basic shewhart control chart, specifically x-bar, r, and s charts. this template contains a pre-made control chart for sample mean and range, or sample mean and standard deviation (2 worksheets in one). note: in the x-bar & r control chart, the number of observations per sample (n) can be between 2 and 25. in the x-bar & s chart, n must be greater than 4. the control chart template above works for the most common types of control charts: the x-bar chart (plotting the mean of a sample over time), the r chart (plotting the range or max-min of a sample over time), and the s chart (plotting the sample standard deviation over time).

reference [2] is a great online resource that explains the formulas and steps for creating these control charts. these factors are the mean and standard deviation of the statistic w = r/s, respectively and can be found tabulated in most text books or references about control charts. w is commonly referred to as the relative range or studentized range and is used to estimate the process standard deviation when only the sample mean and range are known. this is why the x-bar chart is limited to sample sizes of 2 to 25. the hardest part of creating the s-chart is calculating the c4 factor.

control charts are statistical visual measures to monitor how your process is running over a given period of time. control charts are most of the times used under manufacturing processes in order to check whether the manufacturing processes are under control or not. if some of the points are lying outside of the control limits, the process is said to be not in control. we will draw a control chart to see whether the process is in control or not. the \$ sign used in this formula is to make the rows and columns as constants. drag and fill the remaining cells of column c. you’ll be able to see the output as below.

drag and fill the remaining cell of column d, and you’ll be able to see the output as below. drag and fill the remaining cells with a formula, and you’ll be able to see the output as below. otherwise, the process is said to be behaving abnormally, and we need to make the adjustments among the machineries. we are done with the required information, which is needed to plot the control chart in excel. step 7: press the insert line or area chart dropdown button; you’ll be able to see a handful of line and area chart options available under excel. this is how we can create a control chart under excel. this is a guide to control charts in excel.