Automated Control Chart in Excel (with built-in Data Simulation)

Automated Control Chart in Excel (with built-in Data Simulation)

In this tutorial you will learn how to create an Automated Control Chart in Excel with a dynamic chart range and a built-in, interactive Data Simulation.
Learn step-by-step how to create the automated control chart, that automatically highlights any deviation based on limits you define, how to make the range of that chart dynamic, and how to build a VBA Data Simulation, that adds new random data points to your existing data set.

00:00 Introduction and Demo
03:07 Create the Automated Control Chart
17:25 Make the Chart Range Dynamic
28:23 Create an Interactive Data Simulation in Excel VBA

🔎 EXCEL FUNCTIONS IN THIS VIDEO

For this tutorial we recommend the latest Excel version (Excel in Microsoft 365).

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

You want to become an Excel Power-User?
Take a look at our recommended trainings that you can start with for FREE!

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

You want to show your support and help me grow?
Here is what you can do.

☕ WANT TO MAKE MY DAY?

🔥 MORE AWESOME EXCEL AND POWERPOINT CONTENT

Note: Some of the links in this description are affiliate links, meaning, at no additional cost to you, we will earn a commission if you click through and make a purchase. This supports the channel and allows us to continue to produce videos like this. Thank you for your support!

#excel #automated #controlchart

[bjornotto]

This Channel is a hidden gem, glad the YouTube algorithm lead me here

[jhanolaer]

can you simulate spring mass mesh in excel sir??please.. thank you

[marcelsmeets]

This is not a control chart...this is comparison to specifications..

[karan-aulakh]

An Excellent video to simplify the process. I had a doubt though... couldn't we format the data points as Data Table to keep it dynamic?

[JanStelling]

Great tutorial! As I am working an an application scientist for an analytical instrument supplier, I immediately got new ideas for my next training classes.
However, I saw that the z-axis is not labeled when 20 data points are passed. Is this normal? Did I miss something?

[PaschalisTsi]

Geeky comment: Excel...lent Tutorial. Some years ago, I have made for a customer a similar chart but extended to highlight all violations of "western electric" ruleset, very useful for applying SPC over a process. The dynamic range chart though without VBA code is something I was looking for for ages! Thank you!

[jnhnmk]

Can you help how to compere program language evolution using excel chart please

[ExactProBi]

Awesome Video again! Wouldn't it be more efficient to use Excel Tables feature for data for charts? Tables can auto-expand and chart ranges will increase as well. Also OFFSET function though awesome, it is a volatile function affecting Workbook performance

[pal]

I absolutely adore you. Lets start off with your voice. I could listen to talk to you for hours. You're very engaging, intelligent and produce amazing videos! PLEASE DON'T STOP!

[tristanludwigcruz]

Another awesome and great video tutorial. Thank you for continuing this office lab!

[LuizCarvalhonnf]

I usually don't comment on videos, but I had to comment on this one. Incredible material you created sir. thank you

[DavidTran]

Can you show us how to update the Automated chart controls so that instead of clicking to add random values, clicking the button returns daily actual values? Wanted a way to make the chart looks like it's updating with real data over time.

[nickial]

Thank you for sharing all these amazing tutorials. I would give a high compliment that you are not only an Excel expert, but also an Excel artist. I really enjoy watching all your courses. :)))

[KaynMoony]

Very nice tutorial. I learned a lot about dynamic ranges and how to mark data points in diagrams. I never had the idea of making big points without a fill for markers. Thanks again.
But may I ask, after you added more than 20 data points the X-axis annotations didnt extend. Is there a way to make that dynamic too?

[josebenjaminsanchez]

Hello, Greetings from Colombia. I love to excel. Thank you very much for the tutorial. Spectacular (use translator).

[uweschneider]

Thanks for the great tutorial. It seems I have an issue with the offset calculation in the name definition. The count function does not include/count the fields with the error value #N/A. Any idea what could cause this behaviour?

[Captaan_Ahab]

Amazing tool and tutorial!! However, the subscription access doesn't work anymore, to access the worksheet download. Does anyone have a copy of the worksheet? Or site subscription access is needed.

[ardavan]

For updating the chart to include new data that we add, what is the benefit of OFFSET to TABLE? Thanks

[Thechristykiki]

Thank you, this tutorial is very helpful. Why does my chart format change after hitting the restart button, it resets to sold line and different colors..? I also get a pop-up saying that there is a problem with one or more formula references

[johnstath]

Excellent tutorial. Is there a way to add a selection range for date, so that you display points within a date range?