Make Beautiful Excel Charts Like The Economist (file included)

Want to make charts in Excel that look as good as the ones in The Economist magazine? This video shows you how. We cover three types of charts from The Economist: A special type of Bar Chart, Dumbbell Charts (also known as connected dot plot or before after chart), and Color-Coded Tables. These are professional Excel visuals you can add to your corporate presentation. You can also apply these Excel chart techniques to create other charts you come across from The Economist or elsewhere in news magazines or social media.

You'll learn how to set them up step by step, making your data presentation clear and engaging. This guide is perfect for beginners and anyone looking to improve their Excel skills. By the end of this tutorial, you'll be able to create eye-catching charts that can help in any report or presentation.

🔸 Easy-to-follow chart making in Excel
🔸 Create professional-looking charts like The Economist Magazine quickly
🔸 Tips for dynamic and clear data presentations in Excel

00:00 How to Make a Graph in Excel like The Economist Magazine
00:26 Bar Chart
04:32 Dumbbell Chart
11:07 Sponsor think-cell
12:45 Color-Coded Table
18:36 Outro

➡️ 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!

Many thanks to think-cell for sponsoring this video.

#Excel #theeconomist

[matdob]

Never thought I'd be mind-blown by an Excel tutorial, but this is what you just did. Kudos!

[healerslighthelen]

It's good to see these videos after solving all my problems in Excel. I'm finally going to learn how to use all this data.

[Saad.PS]

The pinnacle of professionalism and creativity ❤❤

[mpicht]

30 years as of Feb 1 that I'm using Excel at work. Again, again and again you're bringing new ways of doing things in professional manner and with smart ideas. Stunning. 👍😎

[lourrutiappt]

Blown-away with these Excel Skills! Amazing!

[lijunchen]

These charts will wow the most critical viewers anywhere. Great tutorial with many tricks.

[FutureCommentary]

Honestly! The Economist for me is the THE best on creating charts, communicating lots of information in a compact way.
I'm right now trying to change how we report end of q budgets and variances. This will come in handy.

[rembautimes]

I looked at those Economist charts when I was in school and it does look professional and elegant. Thanks for showing how its done. Long live Aptos Narrow, unrolling the shame brought by Calibri

[RobertLugg]

So much content. Had no idea how powerful the array functions have become. Excel has experienced a real rebirth over the past few years.

[DreadedOne]

I've been looking for you my entire professional Excel-user life. This is the content and explanations that suit my learning perfectly. Thank you!

[kwanpakshing]

the way you used Excel in this video completely changes the way i see Excel - it can do so much more.

[soroush.]

The pinnacle of professionalism and mentoring 👍🏻👏🏻

[Locomaid]

@Leila Gharani - You blow my mind at least once with EVERY video. Thank you!

[nosai]

I paused a couple of times and followed for the 1st chart; paused many times and followed for the 2nd chart; watched 3rd chart and appreciated how well it was done.. Good tutorial!

[tomek]

This is one of the most impressive videos I've ever watched 🤯

[ymup]

I never regret watching your videos. Every time I learn something practical!

[stephenatakora]

You are simply amazing. I've learnt so much from you and I still am. God bless you.

[Tkourtog]

Of course we watch your videos till the end Leila.... We learn so much from them.... Thank you for sharing this!

[BenjaminRobinson]

The method used for designing charts to those seen in The Economist impressed me greatly. These types of charts professionalism and simplicity that highlight the data without unnecessary decorations. The advice, on color selection and font choice was particularly helpful. Now I see how intricate data can be presented in a comprehensible way. I will incorporate these techniques into my projects! Thank you for the valuable insights! )

[SpotlightImpact]

Love it! This is one of my favorite ways to make horizontal dumbbells. One thing to mind is
If your series have points of switching - blue dots lower and vice versa - I’ve found if you point the difference column to both pos and neg error bars this does the trick! 🎉