Make Beautiful Excel Charts Like The Economist (file included)

🆓 Try think-cell for free: tinyurl.com/xelplus
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.
👉 Business Charts in Excel course is now available 👉 link.xelplus.com/yt-d-eco-biz....
⬇️ Download the free charts workbook: pages.xelplus.com/economist-c...
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 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
➡️ Join this channel to get access to perks:
/ @leilagharani
🎬 LINKS to related videos:
Excel Charts & Graphs: Learn the Basics for a Quick Start: • Excel Charts & Graphs:...
Create Impressive Infographics in Excel: • Build Impressive Chart...
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
More resources on my Amazon page: www.amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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

Пікірлер: 306

  • @LeilaGharani
    @LeilaGharani2 ай бұрын

    Download the file I used in the video from here: pages.xelplus.com/economist-charts-file 👉 Join Business Charts in Excel course 👉 link.xelplus.com/yt-c-eco-bizcharts-course

  • @jcdags

    @jcdags

    2 ай бұрын

    Creating these awesome charts in Excel is great! But, I often find they lose their luster when I transfer to Word, especially tables. How can we successfully transfer tables, especially large ones, from Excel to word without having to reformat them to better fit the page?

  • @user-ww2lc1yo9c

    @user-ww2lc1yo9c

    2 ай бұрын

    what about the snake called python I mean the python langauge?

  • @marvinallama130

    @marvinallama130

    2 ай бұрын

    Dear Ms. Gharani, Good day! I have a question. Is it possible in excel to view data using a drip down list, then edit that data? Example is: Student A has a quiz score of 5 for his first quiz, 10 for his second quiz, then let's say i mistakenly entered 10 but actually it was 9. I hope I said it correctly. English is not my first language. Hoping for a video tutorial reply. Thank you!

  • @andrewbgray

    @andrewbgray

    Ай бұрын

    Leila, I'm getting an error message when I try to download the workbook. Is it still available?

  • @LeilaGharani

    @LeilaGharani

    Ай бұрын

    @@andrewbgray yes. It's still available.

  • @matdob7677
    @matdob76772 ай бұрын

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

  • @fernsehdesign

    @fernsehdesign

    2 ай бұрын

    she does this with every tutorial I watched..

  • @richardaversa7128

    @richardaversa7128

    4 күн бұрын

    Wait until you see the LAMBDA function...

  • @lourrutiappt
    @lourrutiappt2 ай бұрын

    Blown-away with these Excel Skills! Amazing!

  • @Saad.PS2009
    @Saad.PS20092 ай бұрын

    The pinnacle of professionalism and creativity ❤❤

  • @mpicht
    @mpicht2 ай бұрын

    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. 👍😎

  • @RobertLugg
    @RobertLugg2 ай бұрын

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

  • @lijunchen
    @lijunchen2 ай бұрын

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

  • @Tkourtog
    @Tkourtog2 ай бұрын

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

  • @rembautimes8808
    @rembautimes88082 ай бұрын

    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

  • @mahendraroliya8695
    @mahendraroliya86952 ай бұрын

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

  • @Locomaid
    @Locomaid2 ай бұрын

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

  • @soroush.1983
    @soroush.19832 ай бұрын

    The pinnacle of professionalism and mentoring 👍🏻👏🏻

  • @yamilvogeld.2385
    @yamilvogeld.23852 ай бұрын

    This is pure gold! thank you so much

  • @tomek78910
    @tomek789102 ай бұрын

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

  • @stephenatakora8225
    @stephenatakora82252 ай бұрын

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

  • @trailcarver3018
    @trailcarver30182 ай бұрын

    Leila, you are so smart, so concise. You're awesome.

  • @DreadedOne509
    @DreadedOne5092 ай бұрын

    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!

  • @nosai4
    @nosai410 күн бұрын

    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!

  • @LeilaGharani

    @LeilaGharani

    10 күн бұрын

    Thank you! 🙏

  • @kwanpakshing
    @kwanpakshing2 ай бұрын

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

  • @elTIRco
    @elTIRco2 ай бұрын

    This is the best excel graph and chart tutorial so far. Thanks Ms Excel Professor 😊

  • @westleyempeigne6541
    @westleyempeigne65412 ай бұрын

    That’s amazing what you showed us, ways to work with Excel to get really good looking visuals! Sometimes you don’t know whether you do this in Excel, or you do this in PowerPoint and add objects, etc to make it look nicer, which is a lot manual! Thanks for sharing Leila

  • @ahsanali50
    @ahsanali502 ай бұрын

    Mind blown by 3rd chart lookup values ! Amazing

  • @martintatlock8684
    @martintatlock86842 ай бұрын

    I think I was one of the people who asked for this and as ever Leila smashes it! You make it look so easy, and your videos are a great way to learn!

  • @vernacularbarnarchitecture
    @vernacularbarnarchitecture2 ай бұрын

    I am screaming. Long time follower of this channel and long time subscriber of the economist.

  • @Timeless_Trader
    @Timeless_Trader2 ай бұрын

    This is mind blowing. Wow loved these templates. Thank you.

  • @tristangeoffroy9286
    @tristangeoffroy92862 ай бұрын

    Thank you Leila, I m always excited to discover the way you trick Excel to get your goal.

  • @MichelleKC.
    @MichelleKC.16 күн бұрын

    Clear, concise and well explained. Thank you.

  • @lisafridland
    @lisafridland2 ай бұрын

    Your videos are incredible. Thank you!

  • @giorgidvali951159
    @giorgidvali9511592 ай бұрын

    Love all your videos, thank you very much

  • @FutureCommentary1
    @FutureCommentary12 ай бұрын

    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.

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    I agree. I'm also a fan of McKinsey charts.

  • @spilledgraphics

    @spilledgraphics

    2 ай бұрын

    @@LeilaGharani I kindly suggest also checking out graphics from The Financial Times + Five Thirty Eight + Washington Post + Wall Street Journal + New York Times....

  • @yaxmokwa7612

    @yaxmokwa7612

    2 ай бұрын

    I will give it to McKinsey though.

  • @FutureCommentary1

    @FutureCommentary1

    2 ай бұрын

    @@yaxmokwa7612 Entirely possible. I don't read McKinsey's reports nearly as often as I read TE as a subscriber.

  • @apoorvasgala
    @apoorvasgala2 ай бұрын

    Excellent Video Leila. I am learning a lot from your videos. Thanks for sharing your knowledge.

  • @arbazahmad7177
    @arbazahmad71772 ай бұрын

    Excellent as always.... Nice, specially the last one.. Thanks for sharing this valuable tips and tricks..

  • @Saad-Sadiq
    @Saad-Sadiq2 ай бұрын

    Ramadan Mubarak Leila and happy to see you back.

  • @mcarvalhocarvalho1873
    @mcarvalhocarvalho18732 ай бұрын

    Words fail to capture the depth of my enthusiasm for this content. Thank you immensely.

  • @shashankshekhar4441
    @shashankshekhar44412 ай бұрын

    This is terrific. I loved how you used xlookup instead of index and match. Thanks for this video.

  • @diarimachan
    @diarimachan7 күн бұрын

    Thank you. Just what I need

  • @snehlatasingh7303
    @snehlatasingh73032 ай бұрын

    One of the best videos I have recently watched. I wanted to make a lollypop chart but could never do it. Thanks to your simple style of teaching I did it.

  • @chrism9037
    @chrism90372 ай бұрын

    Super-useful, thanks Leila! Those charts are great, very clear to understand.

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    Yay, thanks Chris!

  • @user-ht1xy7ns8w
    @user-ht1xy7ns8w2 ай бұрын

    Another thumb up excel tutorial! Thank you Leila

  • @SpotlightImpact
    @SpotlightImpact2 ай бұрын

    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! 🎉

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    Thanks for sharing your tip!

  • @toddlee933
    @toddlee933Ай бұрын

    Wow, you make it look so easy!

  • @canirmalchoudhary8173
    @canirmalchoudhary81732 ай бұрын

    Last chart was amazing especially picture in cell.

  • @Ishangadhavi
    @Ishangadhavi14 күн бұрын

    Gonna use this for my exams to analyse previous year papers based on subjects/topics , thanks 🤙

  • @jihadalbustanji3760
    @jihadalbustanji37602 ай бұрын

    You are such a great person ... true respects for you personally ..

  • @SunilPatil-ee1ff
    @SunilPatil-ee1ff2 ай бұрын

    It's always great to learn from @LeilaGharani Thankful!

  • @manoharmunipalli6146
    @manoharmunipalli61462 ай бұрын

    Seriously super cool, thanks Leila

  • @ahmedtareq5342
    @ahmedtareq53422 ай бұрын

    Fantastic content, as always! Your videos never fail to impress me, and I particularly enjoyed this segment. Looking forward to seeing more content like this in the future. Keep up the great work!

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    Thank you for the feedback. I'm glad to hear that.

  • @faucillon
    @faucillonАй бұрын

    Leilani I have to congratulate you. It's been a LOOONG while since I last learned something entirely new in Excel. Your dumbell chart was exactly that, and I'm able to implement it basically as is in my recurrent reporting on a monthly basis. Love it. Props to you for a professional video and have my like.

  • @LeilaGharani

    @LeilaGharani

    Ай бұрын

    You're so welcome! Glad you found something new.

  • @kuuuyajim
    @kuuuyajim2 ай бұрын

    Amazing as always! I've been using mostly Power BI now for visualization; however, I still keep on checking your channel for new videos/tutorials so I have tricks up my sleeve I can use just in case. 😀 Thank you, Leila! ⭐

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    Thanks for watching! Hope you found something useful.

  • @MJWinters
    @MJWinters2 ай бұрын

    truly mindblowing ... i hope one day i can transform this into my work as production controller.

  • @josecarlosgoncalves5065
    @josecarlosgoncalves50652 ай бұрын

    Awesome content, been learning so much with your content!

  • @lea-kc
    @lea-kc2 ай бұрын

    Can’t express how great this is! 😍📊

  • @kebincui
    @kebincui2 ай бұрын

    Excellent as always 👍

  • @rajwoodson
    @rajwoodson2 ай бұрын

    love the video - and Im a big economist reader, so thank you.

  • @stacy-mariebennett8760
    @stacy-mariebennett87602 ай бұрын

    Wow! Thanks for sharing this.

  • @humbalapa
    @humbalapaАй бұрын

    Leila - another GREAT video... but you make it look so easy, which means I will need to watch this like 50 times before I get it right! Thank you so much for posting this!

  • @LeilaGharani

    @LeilaGharani

    Ай бұрын

    Thanks for tuning in!

  • @blueslee8352
    @blueslee83522 ай бұрын

    Wow! Great tutorial!

  • @Czechbound
    @Czechbound7 күн бұрын

    Very clear, concise and easy to follow tutorial. Well done. I can see why you have many followers. I'm a new one. Greetings from Prague. CZ

  • @jessicaykeith
    @jessicaykeith15 күн бұрын

    This is amazing! - beautiful looking charts and really easy to make - thank you once more!

  • @LeilaGharani

    @LeilaGharani

    15 күн бұрын

    Glad you like them!

  • @christines5430
    @christines54302 ай бұрын

    This video was perfectly timed and excellent😊! I was working on some new charts today and thinking about how to make them nicer. Thank you!

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    Perfect! Hope we could inspire you. :)

  • @rudiklein
    @rudiklein2 ай бұрын

    Great video! When you do it, it looks so simple and obvious, but I know it isn't when I try. I love the less is more charts.

  • @quentinbricard
    @quentinbricard2 ай бұрын

    Thanks you for this video, that's great!

  • @tabassum7823
    @tabassum782314 күн бұрын

    You are so amazing the explanation you provide is super easy to understand

  • @Dwavard
    @Dwavard2 ай бұрын

    Loving this chart explainer - goodbye dull Excel charts hello awesome ones :-)

  • @michelleclayton1025
    @michelleclayton10252 ай бұрын

    Wish I could give you more than just 1 like. This is amazing!

  • @eslamfahmy87
    @eslamfahmy872 ай бұрын

    creative as usual... thanks a lot

  • @Doc_Hollladay
    @Doc_HollladayАй бұрын

    This is amazing!!

  • @Gefionius
    @Gefionius2 ай бұрын

    Fantastic!! Thank you

  • @skrambl
    @skrambl2 ай бұрын

    Thank you for this remarkably clear, succinct, and informative tutorial.

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    You're very welcome!

  • @cristinacannonero6077
    @cristinacannonero60772 ай бұрын

    Great, Leila!

  • @ebunokesanjo1617
    @ebunokesanjo1617Ай бұрын

    I tried 2 of the 3 excel charts and they came out so beautiful. Thanks Leila.

  • @LeilaGharani

    @LeilaGharani

    Ай бұрын

    Glad you like them!

  • @balrambhui9613
    @balrambhui96132 ай бұрын

    This is great lesson. I like your teaching very much and your didactic voice. Thanks

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    Thank you! 😃

  • @mohammadj.shamim9342
    @mohammadj.shamim93422 ай бұрын

    Leila sensei is the best. Actually, a very impressive illustration. I couldn't even think of it. Thank you so much 😊

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    Thank you so much 😀

  • @joseluisromero5296
    @joseluisromero52962 ай бұрын

    ⭐️ You’re the best. I love you ⭐️

  • @Siechfried
    @Siechfried2 ай бұрын

    Great video, thanks.

  • @aftabsuco5233
    @aftabsuco5233Ай бұрын

    So satisfying ❤❤❤❤ learning

  • @LeilaGharani

    @LeilaGharani

    Ай бұрын

    Glad you enjoyed it

  • @evertondel
    @evertondel2 ай бұрын

    Fantastic, thank you.

  • @MrToughEnough
    @MrToughEnough2 ай бұрын

    Great video as usual Leila. This ciuld be a very interesting series (the most famous charts)

  • @jtremaria
    @jtremaria2 ай бұрын

    Amazing!

  • @giryilham5892
    @giryilham589220 күн бұрын

    I learn from this video for my pitching slides.. thank you so much Leila!

  • @LeilaGharani

    @LeilaGharani

    19 күн бұрын

    Glad to hear it. All be best for your pitches. 😊

  • @etutorshop
    @etutorshopАй бұрын

    Lovely, I didn't know I can bend excel charts like this.

  • @khjkjh651
    @khjkjh6512 ай бұрын

    عالی بود خانم قرنی👌👌

  • @alexanderbenson1602
    @alexanderbenson16022 ай бұрын

    These are some awesome little tricks to make some fancy graphs!

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    Glad you found it helpful.

  • @RajeshBhonkiyaTrainer
    @RajeshBhonkiyaTrainer2 ай бұрын

    always new magic and wonder in every video !!!!!!!!!!!!!!!!!!!!!!!!!!!

  • @aaliyamumtaz4374
    @aaliyamumtaz43742 ай бұрын

    I am following you from al most 3 years, always found very quick and help Full Excel tips, which always help me in my daily reporting.

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    That's great to hear! Thanks for your ongoing support.

  • @robertgutierrezrodriguez9646
    @robertgutierrezrodriguez96462 ай бұрын

    Leila, muchas gracias por compartir tu conocimiento, una forma muy creativa e inteligente de utilizar el excel

  • @MSigs
    @MSigs26 күн бұрын

    It’s really understated in college at every level how needed data visualization skills are across nearly all fields of work. I wish I learned more about excel tools in school and I’m working on my third graduate degree at this point with little to no excel skills taught outside of what I taught myself off KZread. And I’m in a STEM field.

  • @soulstrafer
    @soulstrafer2 ай бұрын

    This is amazing! Thank you for sharing!

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    Glad you enjoyed it!

  • @emmanuelle8032
    @emmanuelle8032Ай бұрын

    Wow ! The dumbbel chart though ! Impressive. Thanks so much for sharing such great tips. Such great reportings ahead ;)

  • @LeilaGharani

    @LeilaGharani

    Ай бұрын

    Glad you enjoyed it!

  • @ihsanmalik9773
    @ihsanmalik97732 ай бұрын

    Super amazing. Always mind-blowing tutorials and I learn a lot from these. KUDOS

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    Thanks for watching!

  • @WaqasAli-dq9wg
    @WaqasAli-dq9wg2 ай бұрын

    Awesome visual presentation though....highly professional and well designed and structured 😊

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    Thank you so much 😀

  • @SavioShetty
    @SavioShetty2 ай бұрын

    Quite helpful, thanks.

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi2 ай бұрын

    Thanks for the share.

  • @user-hi5rt7we9n
    @user-hi5rt7we9n2 ай бұрын

    This is amazing...

  • @TheDigitalOne
    @TheDigitalOne2 ай бұрын

    Thanks, just leaned new ways to manipulate cells in Excel, not that I’m going to manipulate any Excel cells anytime soon, the information does come in handy! 😊😺🥰👩‍💻⭐️💎

  • @SlugBrazil
    @SlugBrazil2 ай бұрын

    Amazing as always... Thanks for sharing ❤

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    Thank you! Cheers!

  • @juliocw
    @juliocw2 ай бұрын

    Excellent Leila!, great content as always! 🔝❤

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    Thank you! 😃

  • @fenerinisg3571
    @fenerinisg35712 ай бұрын

    Excellent as always, thank you

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    My pleasure!

  • @nairobi203
    @nairobi2032 ай бұрын

    Very nice solution. Also easy to follow. Thanks for sharing.

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    Glad you liked it.

  • @balrajvirdee1087
    @balrajvirdee10872 ай бұрын

    Amazing!!!! Thanks so much great tips ❤

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    You are so welcome!