Risk Assessment Chart in Excel

In Excel, creating a risk assessment chart (aka impact / probability chart) is fairly easy. All you need is the risk assessment matrix (with a not so large scale) and about fifteen minutes of time. Once finished you can put this into your favorite presentation software (PowerPoint?) and even make this into a template for the future.

📝 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!

#excel
#msexcel
#doughexcel

[bunnusmusic]

✨it's very easy to create a chart, clear detailed explanation✨. Thank you, sir🤩😇

[brentgarret]

Thank for the tutorial! I have a similar chart for google sheets. I've downloaded as a template. It works great!

[riofeumali]

Hi I came across your video because I was looking for a way to have the scattered dots appear as one only, I mean like yours. I was doing the same thing you've done but my chart appears with sets of scattered dots (1 orange for probability/ 1 blue for impact)? How come your's is just one set of it?

[gohshuyi]

Hi Doug! Could you advice how to prepare a company-wide ( different branches ) Risk Matrix ?

[wayneedmondson]

Hi Doug.. cool chart. I like the gradient fill technique. Too bad the data label placements can't separate dynamically when there are multiple pairings of x and y on changing data. I set up the chart using RANDBETWEEN for the x and y values. With every recalc, the pairings were different and so the previously positioned labels crashed into each other. Never the less, a great idea and technique to be used under the right circumstances and conditions. Thanks for sharing. Thumbs up!!

[MPDACHatgpt]

there is no option called label from cell value when i do format label.

[gohshuyi]

Hi Doug! How if the probability value is in alphabet - A/B/C ( Unlikely/Likely/Very Likely)

[subrinalikram]

my excel sheet does not have the option of values from cell. what should i do??