This video covers how to create a colored (green-yellow-red) risk assessment chart. This is used in project management to compare risk to probability for various task or projects to help aid in decision making. See the link to the article (along with the Macro code) at [ Ссылка ].
If you have Excel 2013 or later, there is a function to add descriptive labels you can actually put labels without any VBA. See video at [ Ссылка ]
If you have Excel 2010 or earlier and experiencing Error 91 this might help. To avoid 'error 91', you must have the object (chart) selected at the time you run the macro. Aslo see [ Ссылка ](v=vs.60)?redirectedfrom=MSDN
Feel free to provide a comment or share it with a friend!
🔔 SUBSCRIBE to my channel ➜ [ Ссылка ]
🏫 Excel Training ➜ [ Ссылка ]
📚 Excel Books & Tech Gear ➜ [ Ссылка ]
⚙️ Tools: Screencasting ➜ [ Ссылка ]
⚙️ Tools: Microsoft Office ➜ [ Ссылка ]
⚙️ Tools: TubeBuddy ➜ [ Ссылка ]
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to [ Ссылка ]
#excel
#msexcel
#doughexcel
-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
[ Ссылка ]
-~-~~-~~~-~~-~-
Create a Risk Assessment Chart
Теги
risk assessmentbusiness reportsdata visualizationexcel dashboardkpi dashboardexcel dashboardsexcel dashboard tutorialtutorialbuild excel dashboarddashboard templateexcel dashboard templatesdougcreating excel dashboardtrainingproject managementtiprisk dashboardmicrosoftrisk matrixrisk analysisrisk assessment training videorisk managementproject riskrisk assessment matrixrisk matricesfree excel dashboardpower query