How to Make a Stakeholder Map in Excel | Impact Over Influence

No video

How to Make a Stakeholder Map in Excel | Impact Over Influence | Change Management Tools

Рет қаралды 138,255

David McLachlan

Күн бұрын

Пікірлер: 115

@Bell-uf9fn 7 ай бұрын

I have successfully completed creating my Stakeholder Matrix by using your tutorial. I would like to express my gratitude towards you, David, for providing such an insightful tutorial. It was a lot easier to follow than I initially anticipated, and I feel much more confident about utilizing the Stakeholder Matrix technique in the future. Thank you once again for your guidance.

@scottkingery3211 Жыл бұрын

The Bob Ross of Excel Spreadsheets!

@lyndseynelson9536 10 ай бұрын

I followed this tonight, and I don’t want to sound dramatic, but it may be my greatest achievement in my career so far 🤣🤣 Thank you. I am normally hopeless at this sort of thing but you made it so easy.

@sharonquarrington4861 2 жыл бұрын

Overlapping points is a huge limitation - but moving the labels is fairly easy. Might want to add that to the video. Thanks!

@user-zc7kc6zz5b 9 ай бұрын

Thank you David, probably the best explained excel tutorial I've watched in years.

@engcabdilaahi7356 2 жыл бұрын

Thank you very much, i was drawing in Ms Word, then i found you here. thank you for they humbleness and kindness

@babilaster 6 ай бұрын

Amazing. This is definitely one of the coolest and useful things I've seen. Thank you so much David!

@zumnantangshak8681 8 ай бұрын

A big thank you, David! I learned quite a lot by developing a risk assessment tool. The step-by-step guidance was really helpful in developing the tool.

@TheSoccerstarFreak Жыл бұрын

Thanks for the great turorial, David. Really appreciate your enthusiasm.

@marscience9387 2 жыл бұрын

Thank you David, you're going straight to heaven.

@squigl3z78 10 ай бұрын

that was a journey . i never thought it would be so much technicals to create a chart

@ayobamiagbe3405 4 ай бұрын

Thank you , very helpful even after 2years

@mauriziomaleddu9961 Жыл бұрын

Thank you David, You are very good teacher, practical and clear, congratuations!!!

@nelsiwempapane62 Жыл бұрын

This was the greatest tutorial ever! Thank you so much.

@ronaldyeo8277 10 ай бұрын

David, thanks so much for this, I am doing Project management for my MBA and our lecturer insisted on a Stakeholder Map of our Business Case!

@manojbala255 8 ай бұрын

Hey David, this is wonderful tool. Could you please help how did the maintain confidence, Keep informed, Monitor and collaborate with come from ?

@patiencealexander2492 4 ай бұрын

I also would like to know how to add these to my own chart!

@eyayatouji4323 2 ай бұрын

waw thank you I enjoyed watching the tutorial and doing it. I thought it is for advanced level. Thank you for making it sound easy. You did amazing job

@nathalieg7913 Жыл бұрын

Dear David, many many thanks for this tutorial, you saved my night lol. Thank you so much (from Paris and Rio)

@nikhilananth6589 2 жыл бұрын

Thank you David for this video. I have been able to work better with my project mgmt class team in my program and create deliverable better

@meetajoshi2268 2 жыл бұрын

@David McLachlan this video helped a lot to make my own Stakeholder metrix without anyone teaching me. This means a lot to me Thanks a lot Dave.

@davidmclachlanproject 2 жыл бұрын

You're welcome, thank you for watching 🙂

@shihanperera1169 Жыл бұрын

Thank you. Great tutorial and helps with my assignments.

@kristiethacker9459 2 жыл бұрын

Really helpful! Clear instructions which helped me create my own map within minutes!

@Potencyfunction 4 ай бұрын

You can also make a coallition between your stalkeholders who have the same interests as your company has. The employee is not such interested in your vision and the whole "shit" is going into the same line. I mean there are two types of people in this world: the ones who conform and have a beaurocratic working life style and live on stagnation for years in the row and they ussualy are satisfacted with their small income/profitability and the ones who are out of coallition/team :the innovative ones, the ones who put in balance the fact that all is boring and society need to improve their life style. Having a coallition of " stagnating " sterotypes does not and will never go into the Blue Ocean for example, speaking of strategy. I mean if you are a fool stupid totally stupid-why the hell you keep people in stagnation. You can not comprehend that people need freedom of move witthout your stupidity or what is wrong in your brain?

@MurilloProenca 10 ай бұрын

Awesome! Thank you very much, David!

@aprezapashya1644 2 жыл бұрын

thanks for your information Dave, the next question is how to give value to each of these individuals

@bushmaster75 20 сағат бұрын

Good Tutorial. But I think implementing Principle Component Analysis by utilizing R Programming would be ideal choice.

@mohdfaik Жыл бұрын

Thank you... nice sheet... well done

@biflatin 2 жыл бұрын

Great work David......very helpful!

@salsharm Жыл бұрын

Thank you David! I learned quite a few things through this video. Really appreciate it. I added differently colored rectangles to show quadrants, and it worked out great.

@LaryVictor Жыл бұрын

Thank you and you have such a great and warm presentation skills. Subscribed straightaway!

@oranje5485 Жыл бұрын

The Bob Ross of excel

@ocri4952 2 жыл бұрын

Thank you for this. You have explained it so well, and made it look so easy, much appreciate it!

@STZ3E 2 жыл бұрын

Excel skills on point my man!

@wowkolkata2189 Жыл бұрын

Great sir..thank you for wonderful tricks👏👏👏👍👍

@anwaribrahim6912 11 ай бұрын

Thank you David🤩

@GuzmanKmilo 2 жыл бұрын

Amazing David! Thank you.

@hollylaw7926 Жыл бұрын

This is brilliant, thank you!

@ndriakitasolonionjanirina6647 2 жыл бұрын

simple, effective and wow !!!

@melindamaniatopoulos4124 2 жыл бұрын

Fantastic tutorial Thank you 😀

@thesparkyninja 2 жыл бұрын

This is excellent, thanks for sharing

@aleememmanuel1110 2 жыл бұрын

it was very helpful. thank you so much for all your great help

@sandrisf Жыл бұрын

Great tool! It can be use for Eisenhower Matrix too!

@externaledition6836 Жыл бұрын

Thank you king!

@SinclairIyama 2 жыл бұрын

Awesome chart! Thanks for sharing such an interesting content. Cheers!

@teferag1483 2 жыл бұрын

Fantastic tutorial, thank you!

@hoangocnguyen6368 2 жыл бұрын

Love this! It’s super duper helpful!

@JULIOISAZA357 2 жыл бұрын

Muchas gracias, Muy útil tu video y muy clara tu explicación. Me sirvió mucho para mi trabajo. Saludos!

@davidmclachlanproject 2 жыл бұрын

De nada, es un placer 🙂

@hasnabruneau787 2 жыл бұрын

thanks david really helpfull.

@paulc4018 11 ай бұрын

Great content this was very helpful.

@kpsocal7369 Жыл бұрын

Fantastic! Thank you!!!

@thomasjones9394 Жыл бұрын

Thank you

@DriveYorCareer Жыл бұрын

awesome video. thanks david.

@realshan3988 Жыл бұрын

Thanks

@AndreasBodin 3 ай бұрын

Absolutely phenomenal walkthrough, David! 🤩🙏🏻 Many thanks for this. How do I make it possible to use statuses Low, Mid, or High instead of 0 to 10?

@nailahreed7791 2 жыл бұрын

This is super helpful! Thank you!! You gained a subscriber :)

@mrjadzia1234 2 жыл бұрын

Thank you so much, that is super helpful

@kalmkrew Жыл бұрын

I used this to create a eisenhower matrix look

@Shazzalu 2 жыл бұрын

Thank you, this was so useful rather than manually pulling together an infographic as I have done in the past. One thing I would like to do is add a sub-title of the Project name. I am sure this used to be possible, but like everything since 365, I can't find the option anymore. Any hints?

@perrymcleod6796 2 жыл бұрын

Great video @David McLachlan. I built a sheet today, and my client loves it! Question: is there a way to create 4 data series (or some other method) for the quadrants and colour them appropriately (Keep Satisified, Monitor....). Thank you for any help you can offer.

@korman9872 10 ай бұрын

Tx sir

@em-ellekaygee6621 5 ай бұрын

This is so useful, but I wonder how to split out the stakeholders who are all in the same space so it's possible to read them? I have tried with the settings but no luck. Please help, David!!

@shakeelahkassim1908 Жыл бұрын

Very useful, thank you. Quick one. What happens to stakeholders who rank 5,5?

@Potencyfunction 4 ай бұрын

I like the mustard x and y axis. It stands out from the normal graphs that are highligted in black. Is not boring and it comes up with the differentation from normal .

@littlegucio Жыл бұрын

Hey David, thank you for the great instruction. What, if I want to make a third column called "Attitude towards the project". Preferebly as a 3D Bubble Chart. I think it is called the Mendelow-Stakeholder-Matrix.

@alishacollins8512 2 жыл бұрын

Can you do something similar for google sheets? I tried to follow but some of the formatting is different.

@Animeechannel 16 күн бұрын

Thank you for this. I have one question, how do you make it populate on the grid if you have more than 20 Stakeholders? Mine stop populating automatically.

@LearnWithVideos2013 2 жыл бұрын

What reading materials would you recommend on impact over influence stakeholder analysis?

@emmanuelbasam1381 Жыл бұрын

Awesome @David! Is it possible to make some tutorials on CPI, SPI and other Project Management key Metrics? Thanks

@thelmalaide6039 2 жыл бұрын

Thank you so much for this David. This has been a great tool and I enjoyed building it as well. Any ideas on how to show relationships (stakeholder network analysis) between stakeholders here? Thank you

@davidmclachlanproject 2 жыл бұрын

Gosh, really good question. I am not sure how to add networks on this sheet other than with manual lines or arrows. Something else that might work, might be an automatic grouping sheet I have (we could group stakeholders together, in departments for example): kzfaq.info/get/bejne/payGfsedseCYqas.html

@TheSharath4321 2 жыл бұрын

Ur Amazing :)

@inncarelimited4692 2 жыл бұрын

How do you add the Labels (Monitor, Maintain Confidence etc?) please

@davidmclachlanproject 2 жыл бұрын

Ah, these ones are just Text boxes. Go to insert > text box, and you can move it to wherever you like 🙂

@perrymcleod6796 2 жыл бұрын

@@davidmclachlanproject I tried that and even tried grouping the text box to the crt but that did not work. Would extra data series for each quadrant do the trick?

@chialinl1855 2 жыл бұрын

I have a difficulty in editing the lable contain (from the number to person01, person02..) in excel (office 2010) Would you kindly advice where I can find this modification?

@Abieee4725 2 жыл бұрын

Thank you David, very clear explanation. However, I didn’t get maintain confidence, monitor, keep informed and maintain confidence updated on my map? Did I miss something?

@davidmclachlanproject 2 жыл бұрын

Those ones aren't labels as such, just add them as text boxes in the appropriate area 🙂

@angelavanek3814 7 ай бұрын

I'm pretty sure that I love you

@e11eme 2 жыл бұрын

Thank you this was useful. However, some of the stakeholders fall on the same point or near, so the labels overlap. Do you have any suggestions to get around this?

@davidmclachlanproject 2 жыл бұрын

Great question! Here are a few ideas: We could separate them by a half point (i.e 0.5). We could select the name boxes and move them a little bit manually. Or, we could put the two (or more) people in the same cell in the table (underneath each other by pressing Alt + Enter for a new line). Hope this helps a bit! 🙂

@perrymcleod6796 2 жыл бұрын

@@davidmclachlanproject Using integers works well.

@mjkb1983 Жыл бұрын

@David is there a way you can filter the stakeholders. For example if you have a large list of customers and you want to filter the stakeholders in separate accounts or geographical location

@JonasvanderWende 4 ай бұрын

Yes, but what happens if you have a lot of stakeholders with equal values? Then, they're all on the same point and you will have lost the overview.

@jordanmcbride5262 4 ай бұрын

When adding additional data, I need help getting the data label to show. Any tips?

@dstrehl 8 ай бұрын

@David McLachlan, how do you automatically fix the Overlapping points?

@fionamcveigh7418 6 ай бұрын

Did I miss a bit of the video where you showed how to put in the "Maintain Confidence" "monitor" labels?

@davidmclachlanproject 6 ай бұрын

Not sure, but they are just text boxes. You can add them by "insert" > "text" 🙂

@denisgerov Жыл бұрын

I have an issue I can't get rid of making my stakeholder map. My stakeholders are not spread according to the numbers in the chart. For example, a stakeholder with 7; 3 is at the same location as one with 3; 7 values for the respective categories.

@vincentnikoikotei606 2 жыл бұрын

Very straight forward and good lesson but too fast

@cressidapumpkin5392 7 ай бұрын

I’m lost at the additional heading to maintain confidence, etc. How to get that additional heading?

@firstbornuk Жыл бұрын

Thanks for this David! One question, if I have two stakeholders with the same X,Y values, their names overlay on the chart and are not easy to read. Is there any way to prevent this happening?

@davidmclachlanproject Жыл бұрын

I usually add a .1 or .2 to one of the people, so it moves them just a bit 🙂

@aahmed29 2 жыл бұрын

How do you color each quadrant? Say if I want each quadrant a different color, how do I add that?

@davidmclachlanproject 2 жыл бұрын

Very good question. This is possible, but not straight forward. First create a Gif picture of the coloured quadrants you want (you can use PowerPoint to create it on a full page and save/output as a Gif file). In Excel on your scatter plot, right click the chart area, choose Format Plot Area > Fill > Picture or Texture Fill. In "picture source" you can use your quadrant picture as your chart background 🙂

@aahmed29 2 жыл бұрын

@@davidmclachlanproject It worked. Thank you for your help!

@AhsanoorRashid-fg8zu 3 ай бұрын

Can this be done in Google Sheets?

@user-wu6ek3zv8z 8 ай бұрын

How do i resolve overlapping values in the graph?

@torontawy Жыл бұрын

Can you offer the sheets you create online as examples ?

@brentwood321 Жыл бұрын

How did you add the maintain confidence and collaborate with etc labels?

@davidmclachlanproject Жыл бұрын

Those ones are text boxes.

@jackieo7113 15 күн бұрын

Can you give the name of this specific XL doc? When I go to your site I see a myriad selection and can't find this one in particular

@davidmclachlanproject 15 күн бұрын

Hey Jackie, yep! Number 42 in the pack. Got your message on Etsy, will respond there 😊

@nicholasalifa6871 2 жыл бұрын

There is no 'values from the cell' option on the format data label on my Excel. Am I the only one? Can someone help?

@kingdave294 8 ай бұрын

the arrow vanishes if it goes to 0. How to change that?

@kingdave294 8 ай бұрын

solution: instead of the 100% yopu write down half the whole span of the diagram a field above. (in my case from the left to the rigt its 10 long so I wrote down 5)