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
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.
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
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.
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
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!
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.
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.
You can combine the two elements together with the CONCANTENATE function (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-150vcUL6pvA.html) 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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NnoFXSFBtIg.html
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NnoFXSFBtIg.html 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
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
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)))
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.
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NnoFXSFBtIg.html 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
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?
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NnoFXSFBtIg.html 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
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!
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NnoFXSFBtIg.html
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 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!
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
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NnoFXSFBtIg.html
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
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 (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NnoFXSFBtIg.html) , so hopefully you have that option.
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!
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.
+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.
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NnoFXSFBtIg.html
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NnoFXSFBtIg.html
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.
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NnoFXSFBtIg.html 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