Make Impressive McKinsey Visuals in Excel!

Make McKinsey Charts and Visuals in Excel from scratch.

In this video, I make 3 McKinsey visuals in Excel. McKinsey & Company is the most prestigious consulting firm in the world, so they're known to make some of the best visuals in the industry. That’s why I want to show you how to replicate three of their most popular visuals, in Excel. First, we create a radial bar chart, which is like a mix of a pie chart and a bar chart. You can find this inside of the pie charts section in Excel. Specifically, next to a doughnut chart. Second, we make a bar chart to compare one column of numbers inside of the other. This is similar to a budget vs actuals chart. Lastly, we make a stacked bar chart to showcase the demographics in each step of the corporate ladder.

LEARN:

SOCIALS:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Radial Bar Chart Part 1
3:05​ - Eyedropper Trick
4:07​ - Radia Bar Chart Part 2
6:33​ - Unnamed Bar Chart?
12:02 - Stacked Bar Chart

[Influenceless-influencer]

These “recreating visuals” videos are super useful. Thanks. Part 2 and part 3 please

[VINAY_DEVADIGA]

In the Unnamed chart, --> Alternatively you can also create a horizontal range of the values of Year and Quarter, create a linked image through the excel's built in Camera tool and then Format and Resize it as convenient and finally place it on top of the chart, saves a bit of time!!

[HarryPotterFan]

Definitely a part two and three!!! These dashboard videos are the best on YouTube!

[Guriya-Aithani]

I have just started learning excel and your video are giving me confidence and ample knowledge to go in this path

[Jan-sdnc]

Yes we want a part two. These videos are very helpful for me.

[happymystic]

Nice work packed inside an instructive video. A part 2:and 3 would be a perfect roundup of more charts in the McKinsey arsenal. Cheers …

[maniimanii]

Downloaded Excel today, literally found your page yesterday and the quality of content you create is amazing, more visuals please!

[Horn_of_Afrika]

More than 29k views but still 1k likes? Come on guys, let’s like & subscribe. He is teaching us freely.

[amospan]

Really appreciate these recreating visuals walkthroughs. They come in handy, thank you! =)

[Sailingbill]

This is one of the only pragmatic video's I have seen. Thank you for taking the time to do this!

[Max-qydw]

McKinsey uses as Ppt add in called Thinkcell. With such tool it takes you 30 seconds to build charts. Doing it in Excel is really inefficient.

[healthsis]

This is incredible! Many thanks for sharing your expertise with us!

[PoonamShetty]

Thank you soo much Kenji you have made this excel topic easy with your explanations. Yes we want part 2 and part 3 ❣

[giacomobr]

One of the best videos ever! Please prepare part2

[jtb]

What's very cool is that you go for these text labels..I can spend hours assuming they can be automatically done in the chart data..not any more

[xllearner]

I would also like to see a Part 2. Thank you!

[waadabdullah]

Please keep making these re-creating videos.

[mannyuruchurtu]

Bar in bar chart for the second one 👍🏽

[MarkJones-bcvx]

Fantastic examples. You explain making charts in an easy to understand way.

[nishanth]

Now that some interesting thing.
.😮. can't wait for more this type of videos...🙏