Тёмный

Make Beautiful Excel Charts Like The Economist (file included) 

Leila Gharani
Подписаться 2,6 млн
Просмотров 360 тыс.
50% 1

🆓 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

Опубликовано:

 

19 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 311   
@LeilaGharani
@LeilaGharani 3 месяца назад
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 3 месяца назад
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 3 месяца назад
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 2 месяца назад
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
@matdob7677 3 месяца назад
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 17 дней назад
Wait until you see the LAMBDA function...
@Saad.PS2009
@Saad.PS2009 3 месяца назад
The pinnacle of professionalism and creativity ❤❤
@lourrutiappt
@lourrutiappt 2 месяца назад
Blown-away with these Excel Skills! Amazing!
@mpicht
@mpicht 3 месяца назад
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
@RobertLugg 3 месяца назад
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
@lijunchen 3 месяца назад
These charts will wow the most critical viewers anywhere. Great tutorial with many tricks.
@rembautimes8808
@rembautimes8808 2 месяца назад
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
@mahendraroliya8695 3 месяца назад
I never regret watching your videos. Every time I learn something practical!
@Tkourtog
@Tkourtog 3 месяца назад
Of course we watch your videos till the end Leila.... We learn so much from them.... Thank you for sharing this!
@westleyempeigne6541
@westleyempeigne6541 3 месяца назад
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
@Locomaid
@Locomaid 3 месяца назад
@Leila Gharani - You blow my mind at least once with EVERY video. Thank you!
@soroush.1983
@soroush.1983 3 месяца назад
The pinnacle of professionalism and mentoring 👍🏻👏🏻
@kwanpakshing
@kwanpakshing 2 месяца назад
the way you used Excel in this video completely changes the way i see Excel - it can do so much more.
@stephenatakora8225
@stephenatakora8225 2 месяца назад
You are simply amazing. I've learnt so much from you and I still am. God bless you.
@yamilvogeld.2385
@yamilvogeld.2385 3 месяца назад
This is pure gold! thank you so much
@ahsanali50
@ahsanali50 3 месяца назад
Mind blown by 3rd chart lookup values ! Amazing
@DreadedOne509
@DreadedOne509 2 месяца назад
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!
@tomek78910
@tomek78910 3 месяца назад
This is one of the most impressive videos I've ever watched 🤯
@nosai4
@nosai4 22 дня назад
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 22 дня назад
Thank you! 🙏
@trailcarver3018
@trailcarver3018 2 месяца назад
Leila, you are so smart, so concise. You're awesome.
@FutureCommentary1
@FutureCommentary1 3 месяца назад
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 3 месяца назад
I agree. I'm also a fan of McKinsey charts.
@spilledgraphics
@spilledgraphics 3 месяца назад
@@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 3 месяца назад
I will give it to McKinsey though.
@FutureCommentary1
@FutureCommentary1 3 месяца назад
@@yaxmokwa7612 Entirely possible. I don't read McKinsey's reports nearly as often as I read TE as a subscriber.
@elTIRco
@elTIRco 2 месяца назад
This is the best excel graph and chart tutorial so far. Thanks Ms Excel Professor 😊
@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.
@tristangeoffroy9286
@tristangeoffroy9286 3 месяца назад
Thank you Leila, I m always excited to discover the way you trick Excel to get your goal.
@MichelleKC.
@MichelleKC. 28 дней назад
Clear, concise and well explained. Thank you.
@martintatlock8684
@martintatlock8684 2 месяца назад
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!
@lisafridland
@lisafridland 3 месяца назад
Your videos are incredible. Thank you!
@giorgidvali951159
@giorgidvali951159 3 месяца назад
Love all your videos, thank you very much
@Timeless_Trader
@Timeless_Trader 2 месяца назад
This is mind blowing. Wow loved these templates. Thank you.
@mcarvalhocarvalho1873
@mcarvalhocarvalho1873 3 месяца назад
Words fail to capture the depth of my enthusiasm for this content. Thank you immensely.
@jihadalbustanji3760
@jihadalbustanji3760 2 месяца назад
You are such a great person ... true respects for you personally ..
@SpotlightImpact
@SpotlightImpact 2 месяца назад
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!
@vernacularbarnarchitecture
@vernacularbarnarchitecture 3 месяца назад
I am screaming. Long time follower of this channel and long time subscriber of the economist.
@shashankshekhar4441
@shashankshekhar4441 3 месяца назад
This is terrific. I loved how you used xlookup instead of index and match. Thanks for this video.
@canirmalchoudhary8173
@canirmalchoudhary8173 3 месяца назад
Last chart was amazing especially picture in cell.
@diarimachan
@diarimachan 19 дней назад
Thank you. Just what I need
@Ishangadhavi
@Ishangadhavi 26 дней назад
Gonna use this for my exams to analyse previous year papers based on subjects/topics , thanks 🤙
@apoorvasgala
@apoorvasgala 3 месяца назад
Excellent Video Leila. I am learning a lot from your videos. Thanks for sharing your knowledge.
@Saad-Sadiq
@Saad-Sadiq 3 месяца назад
Ramadan Mubarak Leila and happy to see you back.
@arbazahmad7177
@arbazahmad7177 3 месяца назад
Excellent as always.... Nice, specially the last one.. Thanks for sharing this valuable tips and tricks..
@MJWinters
@MJWinters 3 месяца назад
truly mindblowing ... i hope one day i can transform this into my work as production controller.
@kuuuyajim
@kuuuyajim 3 месяца назад
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 3 месяца назад
Thanks for watching! Hope you found something useful.
@toddlee933
@toddlee933 Месяц назад
Wow, you make it look so easy!
@SunilPatil-ee1ff
@SunilPatil-ee1ff 2 месяца назад
It's always great to learn from @LeilaGharani Thankful!
@MSigs
@MSigs Месяц назад
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 RU-vid. And I’m in a STEM field.
@rajwoodson
@rajwoodson 3 месяца назад
love the video - and Im a big economist reader, so thank you.
@user-ht1xy7ns8w
@user-ht1xy7ns8w 2 месяца назад
Another thumb up excel tutorial! Thank you Leila
@chrism9037
@chrism9037 3 месяца назад
Super-useful, thanks Leila! Those charts are great, very clear to understand.
@LeilaGharani
@LeilaGharani 3 месяца назад
Yay, thanks Chris!
@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!
@snehlatasingh7303
@snehlatasingh7303 3 месяца назад
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.
@kebincui
@kebincui 3 месяца назад
Excellent as always 👍
@ahmedtareq5342
@ahmedtareq5342 3 месяца назад
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 3 месяца назад
Thank you for the feedback. I'm glad to hear that.
@manoharmunipalli6146
@manoharmunipalli6146 3 месяца назад
Seriously super cool, thanks Leila
@josecarlosgoncalves5065
@josecarlosgoncalves5065 3 месяца назад
Awesome content, been learning so much with your content!
@rudiklein
@rudiklein 3 месяца назад
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
@quentinbricard 3 месяца назад
Thanks you for this video, that's great!
@stacy-mariebennett8760
@stacy-mariebennett8760 2 месяца назад
Wow! Thanks for sharing this.
@lea-kc
@lea-kc 3 месяца назад
Can’t express how great this is! 😍📊
@reulfah
@reulfah 7 дней назад
Amazing as alwaysz thank you Leila! ❤
@LeilaGharani
@LeilaGharani 7 дней назад
Glad you like it!
@tabassum7823
@tabassum7823 27 дней назад
You are so amazing the explanation you provide is super easy to understand
@ebunokesanjo1617
@ebunokesanjo1617 Месяц назад
I tried 2 of the 3 excel charts and they came out so beautiful. Thanks Leila.
@LeilaGharani
@LeilaGharani Месяц назад
Glad you like them!
@christines5430
@christines5430 3 месяца назад
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 3 месяца назад
Perfect! Hope we could inspire you. :)
@jessicaykeith
@jessicaykeith 27 дней назад
This is amazing! - beautiful looking charts and really easy to make - thank you once more!
@LeilaGharani
@LeilaGharani 27 дней назад
Glad you like them!
@Dwavard
@Dwavard 3 месяца назад
Loving this chart explainer - goodbye dull Excel charts hello awesome ones :-)
@robertgutierrezrodriguez9646
@robertgutierrezrodriguez9646 3 месяца назад
Leila, muchas gracias por compartir tu conocimiento, una forma muy creativa e inteligente de utilizar el excel
@giryilham5892
@giryilham5892 Месяц назад
I learn from this video for my pitching slides.. thank you so much Leila!
@LeilaGharani
@LeilaGharani Месяц назад
Glad to hear it. All be best for your pitches. 😊
@Gefionius
@Gefionius 3 месяца назад
Fantastic!! Thank you
@blueslee8352
@blueslee8352 2 месяца назад
Wow! Great tutorial!
@AlanLamb2024
@AlanLamb2024 2 месяца назад
Thanks Leila I liked the first bar chart but really wanted the category labels automatically/dynamically added if new row(s) were added. My solution was similar to prior content from you, "Excel Clustered Column AND Stacked Combination Chart". The basic idea is to add an additional invisible series that displays the Category labels. Firstly, make the data a proper Table, then create the Bar Chart Copy and Paste the data values a second time to the chart, so there are 4 'segments". Set the original series on the secondary Axis, new series on the primary. Update the (reverse) order for both Primary and Secondary vertical axes. Set the secondary Series Overlap to -100% and Gap Width to 0% Add a label to the series/bar that has been split. Set the Label to show Category Name and position as Inside Base, also you turn off "Wrap text in shape". Change the Fill to No Fill for the secondary axis bars. Thats it, try adding a new row to the table. Hopefully, you'll see the bars and Category labels just add themselves.
@mohammadj.shamim9342
@mohammadj.shamim9342 3 месяца назад
Leila sensei is the best. Actually, a very impressive illustration. I couldn't even think of it. Thank you so much 😊
@LeilaGharani
@LeilaGharani 3 месяца назад
Thank you so much 😀
@Czechbound
@Czechbound 19 дней назад
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
@aaliyamumtaz4374
@aaliyamumtaz4374 2 месяца назад
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.
@evertondel
@evertondel 3 месяца назад
Fantastic, thank you.
@skrambl
@skrambl 3 месяца назад
Thank you for this remarkably clear, succinct, and informative tutorial.
@LeilaGharani
@LeilaGharani 3 месяца назад
You're very welcome!
@eslamfahmy87
@eslamfahmy87 3 месяца назад
creative as usual... thanks a lot
@RajeshBhonkiyaTrainer
@RajeshBhonkiyaTrainer 3 месяца назад
always new magic and wonder in every video !!!!!!!!!!!!!!!!!!!!!!!!!!!
@Siechfried
@Siechfried 3 месяца назад
Great video, thanks.
@joseluisromero5296
@joseluisromero5296 2 месяца назад
⭐️ You’re the best. I love you ⭐️
@aftabsuco5233
@aftabsuco5233 2 месяца назад
So satisfying ❤❤❤❤ learning
@LeilaGharani
@LeilaGharani 2 месяца назад
Glad you enjoyed it
@MrToughEnough
@MrToughEnough 3 месяца назад
Great video as usual Leila. This ciuld be a very interesting series (the most famous charts)
@Doc_Hollladay
@Doc_Hollladay 2 месяца назад
This is amazing!!
@alexanderbenson1602
@alexanderbenson1602 3 месяца назад
These are some awesome little tricks to make some fancy graphs!
@LeilaGharani
@LeilaGharani 3 месяца назад
Glad you found it helpful.
@soulstrafer
@soulstrafer 3 месяца назад
This is amazing! Thank you for sharing!
@LeilaGharani
@LeilaGharani 3 месяца назад
Glad you enjoyed it!
@michelleclayton1025
@michelleclayton1025 2 месяца назад
Wish I could give you more than just 1 like. This is amazing!
@etutorshop
@etutorshop 2 месяца назад
Lovely, I didn't know I can bend excel charts like this.
@sudds50
@sudds50 3 месяца назад
This is WILD! Thank you!
@LeilaGharani
@LeilaGharani 3 месяца назад
Our pleasure!
@TheDigitalOne
@TheDigitalOne 3 месяца назад
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! 😊😺🥰👩‍💻⭐️💎
@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!
@SyedMuzammilMahasanShahi
@SyedMuzammilMahasanShahi 3 месяца назад
Thanks for the share.
@balrambhui9613
@balrambhui9613 2 месяца назад
This is great lesson. I like your teaching very much and your didactic voice. Thanks
@LeilaGharani
@LeilaGharani 2 месяца назад
Thank you! 😃
@fenerinisg3571
@fenerinisg3571 3 месяца назад
Excellent as always, thank you
@LeilaGharani
@LeilaGharani 3 месяца назад
My pleasure!
@ihsanmalik9773
@ihsanmalik9773 2 месяца назад
Super amazing. Always mind-blowing tutorials and I learn a lot from these. KUDOS
@LeilaGharani
@LeilaGharani 2 месяца назад
Thanks for watching!
@user-hi5rt7we9n
@user-hi5rt7we9n 3 месяца назад
This is amazing...
@SlugBrazil
@SlugBrazil 2 месяца назад
Amazing as always... Thanks for sharing ❤
@LeilaGharani
@LeilaGharani 2 месяца назад
Thank you! Cheers!
@borstenpinsel
@borstenpinsel 3 месяца назад
Xlookup with pictures? This is awesome. I need to try this asap. In the past I've used the camera tool in combination wit offset() but that makes the quality of the image worse somehow. Recently I've used Emojis because there is still no way to add your own icons in conditional formatting. This might be a game changer. Thanks for the tip! 😊
@SavioShetty
@SavioShetty 3 месяца назад
Quite helpful, thanks.
@balrajvirdee1087
@balrajvirdee1087 3 месяца назад
Amazing!!!! Thanks so much great tips ❤
@LeilaGharani
@LeilaGharani 3 месяца назад
You are so welcome!
@juliocw
@juliocw 3 месяца назад
Excellent Leila!, great content as always! 🔝❤
@LeilaGharani
@LeilaGharani 3 месяца назад
Thank you! 😃
@jtremaria
@jtremaria 2 месяца назад
Amazing!
Далее
Fast & Easy! McKinsey Chart in Excel. Watch this...
10:38
You Won't Believe These Crazy PIVOT TABLE Hacks!
11:30
Просмотров 666 тыс.
Must-have gadget for every toilet! 🤩 #gadget
00:27
How to Make Money with Excel Skills
12:56
Просмотров 389 тыс.
Don't Do This: Top 5 Mistakes in Data Visualization
6:02
This ~NEW~ Excel Function is Shockingly Powerful!
9:37
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Excel's NEW Checkboxes Are Incredibly Cool! Here's why
14:24
Make Impressive McKinsey Visuals in Excel!
16:47
Просмотров 260 тыс.
Don't Use ChatGPT Until You Watch This Video
13:40
Просмотров 1,5 млн