MENU

Fun & Interesting

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

David McLachlan 96,782 4 years ago
Video Not Working? Fix It Now

⭐️⭐️⭐️ GET THIS TEMPLATE PLUS 52 MORE here: https://www.etsy.com/listing/1199800561/50-project-management-templates-in-excel 👍 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 Excel and Project Management playlist here: https://www.youtube.com/playlist?list=PLEWFSKHjyrwydP0YBztsIdu47Csvp5KXf

Comment