Making a Control Chart in Excel (with dynamic control lines!)

👍 Ready made and ready to use.

Follow along and learn how to make a Control Chart in Excel, with upper and lower control limits and dynamically moving labels.

See how to make a straight horizontal line on a line chart (for the upper and lower control limits).

Timestamps:
00:00 Intro and Control Chart overview
01:01 Starting with blank template - colours
01:27 Making the data table
02:59 Creating the Upper and Lower control limit data
04:46 Creating the control chart basics
06:48 Adding the UCL and LCL lines on the control chart
08:45 Dynamic named labels for the UCL and LCL lines
10:25 Outro and sheet overview

#Excel #SixSigma #ProjectManagement

[campbellwalker]

Mate, you may very well have saved my assessment from going into the fire, Thank you for your hard work at making such a easy to follow video, it is a mark of a true teacher to make the seemingly complex, simple to follow, Thank you again.

[someguy]

A very good guide that gets to the point and does everything simple. This was a life saver, thanks!

[cornicheebrewer]

Literally followed his directions had to pause multiple times but I did it!

[LCTesly]

Thank you, David! You made learning and understanding it so much better.

[Xploremoments]

I can not thank you enough for your precise and clear explanation. You really helped me to do my assignment correctly. Thanks

[volante.moonsamy]

Thank you for sharing the video. I was able to put together a QC Chart for a year's worth of data in a few hours.

[jasonhunter]

You are the absolute GOAT!!! You never fail me brother

[SpiderPy]

Thanks, it was very useful for my school homework!
Very well explained sir!

[tapiwanalwimba]

Great content and always on the mark. I honestly love your videos so helpful and insightful🤧🤩

[lovetome]

Thanks a lot. Keep doing such excellent knowledge sharing

[reaganokongo]

I love this you are doing a very excellent job, keep it up

[vezmin]

Tq, most useful information and good explanation❤

[francescahamilton]

Thank you very much. It is explained very clearly. Now I know how to impress my director :)

[supersport]

Thank you for the video! Helped me so much. Can you get to the same result without the inputs in chart form? What if I have the dates and values across a horizontal row?

[paulanton]

Thank you so much. Really appreciated. Informative video.

[markbassett]

Nice job - thank you. I learned some new tricks!

[degracemuzik_band]

This will help me close my audit non compliances.

[EC]

How are the USL and LSL added into the control chart?

[michaelfarrell]

I'm struggling to get my head round one thing... why would you want your control limits to be dynamic? Imagine the scenario where you have a data point that should sit just outside your CL. But because the CL is dynamic, it shifts so the new data point is now within the CL. It's kind of a self fulfilling prophecy! Shouldn't you use historical data to establish fixed control limits, then see where new data points fall in relation to those limits? Thanks in advance 🙂

[TheEngineeringToolboxChannel]

Thank you for the video, but I wanted to point out that this is NOT the correct way to calculate control limits for control charts. In control charting the sigma symbol is not the same as typical standard deviation. It is calculated using different methods (depending on the type of the chart) that takes into consideration the relative shift of the process over time. This is by design and it is very critical that sigma is calculated correctly for a control chart to be useful.
In your case, sigma should be calculated as [sigma = MR/d2] MR is the moving range of each successive data point and d2=1.128 (the scalar constant for control charts where sample size is n=1). I encourage people to compare both ways with real data and you will see how much different the values are. Using global standard deviation (as you have) will severely inflate the control limits and can give you the false impression that a process is in control when it is likely not. The reason 3*SD seems too far away is because it’s not the right calculation. Calculating the sigma value correctly will show many of the data points are out of control even with 3*sigma.

Apologies for the rant but i see this error too often. Too many MBAs who took a stat class thinking this is what statistical process control is.