Create a Risk Assessment Chart

[@kebinabraham2277]

For those who does not know how to create or run a macro. The solution to have the Risk factors R1 to R11 appear on the chart itself is to use the text box feature and put the text boxes near to the points on the graph and type in the required Risk factors. Thanks a lot for the video and detailed instructions

[@DougHExcel]

Hi Kebin Abraham, thanks for adding to the thread!

[@conhoolio3683]

You can also choose to show data labels then right click any label and goto "Format Data Labels". Under "Label Options" tick "Values from cells" and use the "Select Range" button. This will select a whole column of labels. This might not be compatible with older versions of excel.

[@mim.candy8]

I won't lie but this has been the best educative and well explained video I have ever watched. Thank you! I was able to a create a clear pretty risk assessment matrix

[@DougHExcel]

Thanks Shamim candy, glad it helped!

[@idmbadvisoryltd3205]

They seem to have fixed the label problem in 2016, so it saves messing with a macro.Good video!

[@Watchingyou-daily]

Yes I noticed that but one thing I am having issues with is the Axis titles

[@armab22]

Thank you so much, 8 years later still helps!

[@DougHExcel]

Glad it helped!

[@boloth835]

wow, thanks man, you're amazing

[@DougHExcel]

You're welcome!

[@anarosaneves2015]

Guys, error 91 it's easy to fix: you just have to run the macro with the selected graphic! Love it!

[@lukediamond2078]

Totally! It does work.

[@DougHExcel]

Thanks for adding to the thread!

[@erceleste1]

wow this video is amazing- i always try to follow these and they never seem to work. This one came out perfectly, i was very pleased!! thank you!!!

[@DougHExcel]

Glad it helped!

[@syrinekhoury3576]

You are an absolute star! Thank you so much for this invaluable feedback!!!

[@DougHExcel]

Hi Syrine khoury, thanks for the kind words!

[@TheKKamra]

Well done. I use GRC tool and it doesn't support Heat Map as i want it but after watching this video i was able to create heat map the way i want it. Thank you Doug. Really appreciate it.

[@DougHExcel]

Hi K Kamra, thanks for the comment!

[@caraleerustichelli4555]

I wanted to blow excel up but you saved the day, THANK YOU!!!

[@DougHExcel]

You’re welcome!

[@stephicohu]

He did a great job. The macro is no longer needed because in 2016 the fix the ability to add a name. Use the left mouse button and use edit text command

[@islammo5026]

could you tell me how i do that?

[@stephicohu]

I can you must have office 2016 to make this work. Do you have office 2016? Use the scatter option in Excel.

[@islammohamed2395]

stephicohu thanks I got it

[@saifbeingsaif]

Could you explain this further? where is edit text command?

[@poilou2607]

On a graph : + < Data Label < More Options < Histogram button < Label Options < Label Contains < Value From Cells !!!!

[@excelisfun]

Great Chart!!!! Nice VBA too!

[@gloggnitz13]

Very useful and well explained. To improve: try not to narrate continuously but pause after you make a point. Keep up the good work

[@atikorkojogodwin3489]

Hello ,please the first link you attached is not working

[@abood6643]

Excel 2013 solved this problem I think . Thanks for the great video

[@DougHExcel]

You're Welcome!

[@samiafathi3757]

Hello what about error 5? Help pls

[@lukediamond2078]

Love it, very well explained Doug H. I use this to create an Impact effort matrix.

[@DougHExcel]

Glad you liked!

[@robinmathews4928]

What do I do if I get an error "run-time error 91. Object variable or with block variable not set? Can you help me fix this?

[@DougHExcel]

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 kzbin.info/www/bejne/hJ_Sd4uJe6enf8k 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 docs.microsoft.com/en-us/previous-versions/visualstudio/visual-basic-6/aa264506(v=vs.60)?redirectedfrom=MSDN

[@kritikakumar4034]

Thank you so much for this tutorial. Helped me to fix some problems while creating a risk matrix.

[@DougHExcel]

You're Welcome!

[@oliadd9655]

It really works! Nice and helpful video

[@DougHExcel]

Glad it helped!

[@burhanelald8558]

when i click the macro section (as you did in 6.00), I get an error which is run time error 91 object variable or with block variable not set. How can I fix it?

[@DougHExcel]

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 kzbin.info/www/bejne/hJ_Sd4uJe6enf8k 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 docs.microsoft.com/en-us/previous-versions/visualstudio/visual-basic-6/aa264506(v=vs.60)?redirectedfrom=MSDN

[@burhanelald8558]

@@DougHExcel thank you ^^

[@ettenadra]

Watching this in 2022. From the 3minute labelling mark, you can now select labela from a range. Just right click > data labels > label options > value from cells (select range) Otherwise still a very helpful video!

[@DougHExcel]

Hi Arnee P, thanks for the comment!

[@smiley5799]

Need help in less than a day!! When I try to run macro, I get an error which's like: Run Time Error '91'. Object variable or with block variable not set.

[@DougHExcel]

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 kzbin.info/www/bejne/hJ_Sd4uJe6enf8k 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 docs.microsoft.com/en-us/previous-versions/visualstudio/visual-basic-6/aa264506(v=vs.60)?redirectedfrom=MSDN

[@marcelf.284]

Is there any workaround to avoid overlapping labels or having to manually rearrange overlapping labels?

[@DougHExcel]

You'd have to manually move it around 😐

[@aigor-br]

Thank you so much for this class Doug! Great job.

[@DougHExcel]

Thanks André Oliveira!

[@josephvthanikal6605]

I am not able get that RESOURCE from microsoft site

[@DougHExcel]

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 kzbin.info/www/bejne/hJ_Sd4uJe6enf8k

[@nomaden09]

thank you bro.. you helped me alot in doing my mid term test..

[@DougHExcel]

Thanks Rifky Adhlan Nomaden, glad it helped!

[@EricOsterberg]

I'm getting a 404 missing page when searching for KB213750 or following the link. Can anyone provide a copy? Or another link?

[@DougHExcel]

try the updated link in the description of video

[@ejosterberg]

@@DougHExcel Thanks for the quick updates.

[@murtazajabalpurwala8124]

Hey can you share the VB code that you had written while creating the module

[@DougHExcel]

See the link to the article (along with the Macro code) at support.microsoft.com/kb/213750

[@CatchTwenty2withDeola]

Thank you so much for this🙏🙏

[@DougHExcel]

You’re welcome!

[@leemingwee99]

please tell me what is the formula in visual basic that you wrote so now I need to know about this how to put the risk reference number in the chart

[@OmarAlimam-cj3qq]

sir can you send the code to me please.

[@edwardpersaud]

Hi is there a more newer process to this? Great vid

[@DougHExcel]

Hi forte, thanks for the comment! new vid/process? maybe I'll look into it 😁

[@lynettepatterson8172]

This is great, except the Macro didn't work. I don't know anything about VB, can someone help me? The debug highlights the following part of the script. xVals = Mid(xVals, InStr(InStr(xVals, ","), xVals, _ Mid(Left(xVals, InStr(xVals, "!") - 1), 9)))

[@joedutchnl3948]

Same here

[@lenamadlene]

Great help! Thank you, helped to create me a nice looking risk matrix

[@DougHExcel]

Thanks lenamadlene, glad it helped!

[@yosibest]

I can't get Macros to work I get the following xVals = ActiveChart.SeriesCollection(1).Formula Can anyone help?

[@DougHExcel]

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 kzbin.info/www/bejne/hJ_Sd4uJe6enf8k

[@TheFeerozac]

Thanks for this, its really helpful! Keep posting!

[@DougHExcel]

Hi Mark Syed, thanks for the comment!

[@MichaelVitulli]

Thanks - this is quite helpful

[@Mohamed-Elyas]

Very informative, Great job.

[@viewersthunai2313]

N13?

[@DougHExcel]

Sorry, don’t understand the comment/ question...

[@lgunt004]

You can customize the macro labels in Excel 2013 by right clicking > format data labels > under label options select "value from cells"

[@tarin6131]

Thank you

[@Claire-bq1eg]

Thanks for this video! Any tips on how to do this on Google sheets? Specifically regarding how to label your data points R1,R2 etc? And how to separate the plots as you have done here in excel? Thanks

[@DougHExcel]

Great suggestion; maybe a google sheets video in the future 😁

[@usernameinternet7962]

@@DougHExcel Hi! I have the same question! Made this chart based on your video, but when I export it to sheets it looses the macros function and there is no options to make a macro in sheets. Any suggestions how to get this working? And a big thanks for the tutorial!

[@rosalbafuentessoto9114]

I will have an exam and thanks lol, it will be very useful for me

[@DougHExcel]

Best of luck!

[@jesusomarplascenciafrias8878]

You are the man!

[@DougHExcel]

Thanks for the comment!

[@jesusomarplascenciafrias8878]

how can i correct this error Object variable not set (Error 91)

[@efoussat]

Hi, is it possible to get the excel risk assessment chart file directly ? That would be great… (not working to create it for me, i get VB bugs). Thanks a lot

[@DougHExcel]

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 kzbin.info/www/bejne/hJ_Sd4uJe6enf8k

[@Goldenratio380]

thanks for the turotial.Really helpful!

[@DougHExcel]

Thanks Nurul Nadia, glad it helped!

[@vincenteagleton7530]

Hi Doug, Quick question- if we change the "risk number" after we have imported the macro, will it still auto update it to the graph used? We had to remove a few risks and now it changed the numbering of the risks.

[@DougHExcel]

if you have later versions of excel, you don't need the macro...see the link in the description on how to use.

[@JeffersonSilva-cr4uh]

Nice, bro!!! It helps me a lot!!!

[@ricardogertiser]

Hi, I did exactly as you mention, but when I run the macro it says "Run-time Error 91. Object variable or with variable not set." Do you know what can be wrong? Thanks!

[@DougHExcel]

try to redo this from scratch...as i understand that error has something to do with something not properly entered. As an alternative, if you have Excel 2013 or greater the macro is not needed anymore for label creation. See kzbin.info/www/bejne/hJ_Sd4uJe6enf8k

[@jeandorsch8187]

When I try to run the macro, I get the following error message: Run-time error '91': Object variable or with block variable not set. Can you tell me how I can fix it. I tried deleting the module and recopying the instructions, but I get the same message. (I am using Excel 2013) The debug is pointing to one line that says: xVals=ActiveChart.SeriesCollection(1).FormulaThank you!

[@ellainecatu-ninalga2664]

this might help: msdn.microsoft.com/en-us/library/aa264506(v=vs.60).aspx

[@DougHExcel]

Hi Jean Dorsch, thanks for the comment!

[@MegaFantabuloso]

Thank you Dough... could you please let me know how do we arrive at impact & probability. Thanks again.

[@MegaFantabuloso]

Thank you

[@mishrapawan2218]

Wonderful information thanks tomorrow I will preapare

[@DougHExcel]

+Mishra Pawan glad u liked it!

[@stephendenton1703]

Doug, Great help. Thank you for making the effort. Very helpful. I don't suppose you could tell us how to import this type of spreadsheet into a Power Point so it is still functional within the Power point.

[@stephendenton1703]

+Doug H Thanks. Yes thats exactly what I want to do. For now I've just inserted a hypo link into the PP which throws me to the spreadsheet where I can demonstrate the changes required.

[@moezouusji7542]

Could i have the link please thank you so much

[@DougHExcel]

You're welcome, sorry no link to files

[@tomcola58]

This is very helpful but I got stuck getting the macro. Can you publish the link?

[@viclola2002]

Hi Doug, pls can you help me with what i can do if i want to change the first column (Risk Factor ) to alphabet such as Liquidity Risk, Credit Risk e.t.c. How will i do this to avoid Run time error 91

[@DougHExcel]

Not sure on the run time error. You might need to just create it again and run it. Excel 2013 now has the option of creating labels from a user define selection (kzbin.info/www/bejne/hJ_Sd4uJe6enf8k) , so hopefully you have that option.

[@Raven-ko9tl]

Sir do you have more videos related in how to conduct a complete Risk Assessment

[@DougHExcel]

Hi Raven, thanks for the comment! How to make a charts, but not the process of conducting...

[@varidhidcruz7990]

where do i get the code

[@DougHExcel]

check in the video description

[@harshilsheth4842]

Hi Doug, I am using a 3-D scatter chart with all my axis and bubble size with the right information. The issue is labeling the bubbles. I want to label it by combining two different elements. I saw you used VBA codes to label your graph. Is it possible using VBA to customize the labels as I want it? Thank you.

[@DougHExcel]

You can combine the two elements together with the CONCANTENATE function (kzbin.info/www/bejne/Z2aTp5aLgZujrKM) or the ampersand (&) into one cell to use with the VBA. If you have Excel 2013, it lets you add custom labels without the VBA. This video shows example kzbin.info/www/bejne/hJ_Sd4uJe6enf8k

[@Halmi42]

worked perfectly thank you a lot

[@DougHExcel]

You’re welcome!

[@vishnubaskaran]

where can i get this macros

[@DougHExcel]

it's at Microsoft support.microsoft.com/kb/213750

[@mariosilva903]

Great job. But how exactly can I get the macro ? Thanks.

[@DougHExcel]

The description field of the video page will have the link to Microsoft site for the macro.

[@mariosilva903]

Okay, thank you, Doug.

[@SaqibAli-nn7ut]

Hi Doug, Thanks for the informative video it's helped me a lot. Just one question when i have my list of columns with my information in them, if i choose to change the information in the first column why does this not update on my actual chart? Thanks

[@상은-v1n]

thank you, this is very useful~!! great~

[@leemingwee99]

Thank you very much that you tech this video thank you so much

[@alexrosen8762]

Superb. Thank you!

[@DougHExcel]

You're Welcome!

[@aaaaaaaaalife]

Love this

[@DougHExcel]

Thanks!

[@BrunoFerreira-si4vm]

great help... added to my playlist for future help/reference... hope it's ok with you. thanks for the help :-)

[@vhugolobo17]

Good video!

[@DougHExcel]

Thanks for the comment!

[@ChooseU4ever]

Great video, but the macro doesnt work. i get error 91

[@DougHExcel]

if you have excel 2013 or later, the macro is not needed....see kzbin.info/www/bejne/hJ_Sd4uJe6enf8k

[@ChooseU4ever]

Thank you..

[@kebincui]

Super 👍👍

[@DougHExcel]

Thanks 🙏

[@HMichaelLaFrance]

Your "Microsoft products:" tiny URL is give the following error: This webpage has a redirect loop ERR_TOO_MANY_REDIRECTS Update: I was able to get the macro from the URL in your vid, thx.

[@FrogRunner4x4]

Where? I am trying to find it and cannot locate it. Thanks!

[@murtazajabalpurwala8124]

there is a runtime error 91

[@DougHExcel]

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 kzbin.info/www/bejne/hJ_Sd4uJe6enf8k If you have Excel 2010 or earlier and experiencing Error 91 this might help docs.microsoft.com/en-us/previous-versions/visualstudio/visual-basic-6/aa264506(v=vs.60)?redirectedfrom=MSDN

[@muhammadyounus7691]

Thank you.

[@DougHExcel]

You're Welcome!

[@antonellabortolazzo7299]

Thanks a Lot!!

[@DougHExcel]

You're Welcome!

[@alpels]

thanks!

[@DougHExcel]

You're welcome!

[@parvathypillai4291]

Thanks

[@DougHExcel]

You're Welcome!

[@karolinarychlinska5656]

support.microsoft.com/en-gb/help/213750/how-to-use-a-macro-to-add-labels-to-data-points-in-an-xy-scatter-chart link to get the macro

[@DougHExcel]

Hi Karolina Rychlińska, thanks for adding to the thread!

[@embe2008]

thank you, this is very useful~!!

[@DougHExcel]

You’re welcome!