Fast & Easy! McKinsey Chart in Excel. Watch this...

Learn to quickly make professional charts in Excel. These are simple, modern Excel charts that communicate your data clearly and in an engaging way.

This tutorial shows you how to design charts similar to those used in top industry reports. They fit in any corporate report or consulting presentation. The best part? We use a simple Excel function to create the chart. This is Excel's hidden Chart Function! The method is ideal for improving your business reports with effective visuals, without the need for complex software. Just with a few clicks you'll be able to create an impressive McKinsey chart in Excel. This McKinsey chart is often referred to as the lollipop bar chart or the pin horizontal chart.

You can also use this Excel function to create a super fast bar chart in Excel. Tweak it to create a star bar chart or use any symbol you like. It's so flexible and easy, you'll love this simple Excel hack.

Learn about:
◊ Using the REPT function to customize chart bars with emojis and symbols.
◊ Modifying charts dynamically to adapt to data changes instantly.

For more detailed insights and advanced techniques, check out our full course on Business Charts in Excel. This course is designed to help you create charts that stand out in any professional setting, mimicking the sophisticated styles seen in publications like The Economist and McKinsey reports.

00:00 Use THIS Excel function to Create a McKinsey chart
00:30 Create a Excel McKinsey Chart in 90 seconds
02:24 Customize the Chart
06:49 New Course: Business Charts in Excel

➡️ Join this channel to get access to perks:

🎬 LINKS to related videos:

🚩Let’s connect on social:

This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[notesfromleisa-land]

I will attest to the quality of Leila’s courses. I’ve only taken the Power Query course which I needed for a data triage train wreck. I had muddled through it on my own initially. The course was a life and time saver. The cost and time of the course was a fraction of the time, effort and frustration I saved. I think that this course is next. I’m an old dog and need this new trick. Users are so lucky today to have access to high quality videos from trusted professionals to help us increase and refine our excel skills. It was dark days on the frontier back in the day.

[smguy]

Great video! But unless I missed it, there was no explanation of what you did in the part about scaling numbers back when you are presenting large numbers? Was it just to divide the larger number by a large number to get the rept function to show less? And how did the bars accommodate the text added like "VIP campaign" and "announcement"?

[teemad]

Leila, great video as always. I have to say however, you may be one of the world's top Excel resources and no doubt you love what you do, but you are missing your true calling. Comedy! The timing first on the "woah, wait" bit and then the coffee sip was just comedic genius! 🤣

[ManafKAMIL]

Brilliant... and I totally agree with you, the coffee sip at the start is very important 😁

[kdub]

Your presentations and demos are always flawless! I love that you can take a seemingly complex Excel format and not only make it look easy to follow and learn, but do it quickly and almost effortlessly. Thank you for sharing your knowledge set and making more of us look like spreadsheet savants! 🥰

[quiqueenrikx]

You're simply the best. Thanks!!!!

[BORISVLEONOV]

"Now I'm ready". It was perfect! 😊 Thank you for the video!

[mikecrosbie]

Wish you could do more about excel but on macs, and some hints and tips for work arounds on certain areas where the mac version of excel is lacking

[andrew]

Great video/tutorial.

It shows that Excel can be for much more than complex spreadsheet applications.

[FutureCommentary]

Mind blown. That's it. Just mind blown.

[IOSALive]

Leila Gharani, This is fantastic! I subscribed right away!

[CatharinaDavies]

Thank you Leila, I have already purchased this course and can’t wait to delve in !

[beebop]

QUESTION- hi. I luv your channel. Is there a way to slow down your explanation and keystrokes on the video? I am a bit slower and want to learn.

[walking_on_by]

I still have a few courses to complete, but the business charts course will be the next one. I love your teaching style, makes the courses enjoyable. I've learnt so much from them.

[mr.gk]

Hey I love your videos on Mckinsey and The Economist styles, please do more videos on this topic. Keep up the good work!

[moniquemassen]

Hey Leila, LOVE your tips! In your video you mention that you can change the maximum length of the bars in a field, how do you add that to the formula?

[aleirbag]

This was amazing, thank you! I've been loving these McKinsey and The Economist videos!

[Wio_La]

Dear Leila, thank you for your great work! You are the best teacher I have ever met!

[sao_rav]

You have been a true mentor for all of us. And truly thank you for your contribution to the world. Much love and respect from India 🇮🇳. I sometime wonder how fo you even figure out how these works and get us so clear easy solutions?

[grtraders]

I am falling in ❤ with this lady every single day.

She is simply brilliant with what she has to present.

Jokes apart, I think no one on this planet can teach excel better.

Thank you for teaching us and making the internet worth its existence. Please keep up the good work.