Make Beautiful Excel Charts Like The Economist (file included)

Поділитися
Вставка
  • Опубліковано 30 жов 2024

КОМЕНТАРІ • 339

  • @LeilaGharani
    @LeilaGharani  7 місяців тому +37

    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 7 місяців тому +1

      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?

    • @優さん-n7m
      @優さん-n7m 7 місяців тому +1

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

    • @marvinallama130
      @marvinallama130 7 місяців тому

      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 6 місяців тому

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

    • @LeilaGharani
      @LeilaGharani  6 місяців тому

      @@andrewbgray yes. It's still available.

  • @healerslighthelen
    @healerslighthelen 24 дні тому +106

    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.

    • @Andrea-A5p
      @Andrea-A5p 24 дні тому

      I also have problems and I can't find a way to solve them all because a new one always comes out hahaha

    • @healerslighthelen
      @healerslighthelen 24 дні тому

      Nothing, I got so desperate that I had to look for an office key and that was what helped

    • @Andrea-A5p
      @Andrea-A5p 24 дні тому

      That was what I wanted to avoid but where did you get it?

    • @healerslighthelen
      @healerslighthelen 24 дні тому

      There are many sites but I used BNH Software because I did not want to risk or waste more time.

    • @Andrea-A5p
      @Andrea-A5p 24 дні тому

      I'm going to review it and well I'll have to give in to be able to solve the problems.

  • @matdob7677
    @matdob7677 7 місяців тому +127

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

    • @fernsehdesign
      @fernsehdesign 7 місяців тому

      she does this with every tutorial I watched..

    • @richardaversa7128
      @richardaversa7128 5 місяців тому

      Wait until you see the LAMBDA function...

  • @Saad.PS2009
    @Saad.PS2009 7 місяців тому +72

    The pinnacle of professionalism and creativity ❤❤

  • @mpicht
    @mpicht 7 місяців тому +41

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

  • @FutureCommentary1
    @FutureCommentary1 7 місяців тому +22

    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  7 місяців тому +3

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

    • @spilledgraphics
      @spilledgraphics 7 місяців тому

      @@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 7 місяців тому +1

      I will give it to McKinsey though.

    • @FutureCommentary1
      @FutureCommentary1 7 місяців тому

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

  • @lijunchen
    @lijunchen 7 місяців тому +15

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

  • @mahendraroliya8695
    @mahendraroliya8695 7 місяців тому +5

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

  • @lourrutiappt
    @lourrutiappt 7 місяців тому +12

    Blown-away with these Excel Skills! Amazing!

  • @rembautimes8808
    @rembautimes8808 7 місяців тому +10

    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
    @RobertLugg 7 місяців тому +8

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

  • @DreadedOne509
    @DreadedOne509 7 місяців тому +3

    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
    @nosai4 5 місяців тому +4

    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!

  • @kwanpakshing
    @kwanpakshing 7 місяців тому +2

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

  • @Locomaid
    @Locomaid 7 місяців тому +9

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

  • @soroush.1983
    @soroush.1983 7 місяців тому +4

    The pinnacle of professionalism and mentoring 👍🏻👏🏻

  • @tomek78910
    @tomek78910 7 місяців тому +8

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

  • @SpotlightImpact
    @SpotlightImpact 7 місяців тому +1

    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  7 місяців тому +2

      Thanks for sharing your tip!

  • @MSigs
    @MSigs 5 місяців тому +2

    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 UA-cam. And I’m in a STEM field.

  • @stephenatakora8225
    @stephenatakora8225 7 місяців тому +3

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

  • @BenjaminRobinson77
    @BenjaminRobinson77 Місяць тому

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

  • @westleyempeigne6541
    @westleyempeigne6541 7 місяців тому

    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

  • @Tkourtog
    @Tkourtog 7 місяців тому +2

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

  • @yamilvogeld.2385
    @yamilvogeld.2385 7 місяців тому +9

    This is pure gold! thank you so much

  • @AlanLamb2024
    @AlanLamb2024 7 місяців тому

    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.

  • @felipelackington9118
    @felipelackington9118 7 місяців тому +1

    Hi Leila!
    Today’s sponsor, Think-Cell, is a powerful tool. It would be great to see you showcasing some examples connecting Excel with Think-Cell for more systematic approaches… from number crunching to executive level presentations, just like the graphs you showed today.
    Thank you for your amazing content! You have certainly made my insights a lot better and nicer over these years. Warm regards!

    • @LeilaGharani
      @LeilaGharani  7 місяців тому

      You could check out this video we did some time ago: ua-cam.com/video/gAGIVfL-i8Q/v-deo.html

  • @trailcarver3018
    @trailcarver3018 7 місяців тому +2

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

  • @mcarvalhocarvalho1873
    @mcarvalhocarvalho1873 7 місяців тому +6

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

  • @robsondionisio
    @robsondionisio Місяць тому

    The pinnacle of professionalism 🚀

  • @kuuuyajim
    @kuuuyajim 7 місяців тому +2

    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  7 місяців тому

      Thanks for watching! Hope you found something useful.

  • @ahsanali50
    @ahsanali50 7 місяців тому +1

    Mind blown by 3rd chart lookup values ! Amazing

  • @faucillon
    @faucillon 6 місяців тому

    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  6 місяців тому +1

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

  • @elTIRco
    @elTIRco 7 місяців тому +1

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

  • @Illiakubasov
    @Illiakubasov Місяць тому

    That is how expertise and creativity work together 🤝🤝🤝

  • @humansizedaperture
    @humansizedaperture 7 місяців тому +1

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

  • @Ishangadhavi
    @Ishangadhavi 5 місяців тому +1

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

  • @ebunokesanjo1617
    @ebunokesanjo1617 6 місяців тому

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

  • @canirmalchoudhary8173
    @canirmalchoudhary8173 7 місяців тому +1

    Last chart was amazing especially picture in cell.

  • @Timeless_Trader
    @Timeless_Trader 6 місяців тому +1

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

  • @balrambhui9613
    @balrambhui9613 7 місяців тому +1

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

  • @SpokesAndWings
    @SpokesAndWings 3 місяці тому

    Awesome course (as always)! Just finished. Charts are so much easier now! Thanks so much!

  • @snehlatasingh7303
    @snehlatasingh7303 7 місяців тому

    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.

  • @franreed5382
    @franreed5382 Місяць тому

    Great video. Its fun to learn new techniques with charts.

  • @nsanch0181
    @nsanch0181 3 місяці тому

    I loved the lesson on charts Leila thank you. Can't wait for the business charts course. The Excel Visualization course in Udemy is one of my favorites. I go back to it all the time when I need to do some charting.

  • @mohammadj.shamim9342
    @mohammadj.shamim9342 7 місяців тому

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

  • @christines5430
    @christines5430 7 місяців тому +1

    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  7 місяців тому

      Perfect! Hope we could inspire you. :)

  • @ahmedtareq5342
    @ahmedtareq5342 7 місяців тому +2

    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  7 місяців тому

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

  • @aaliyamumtaz4374
    @aaliyamumtaz4374 7 місяців тому

    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  7 місяців тому

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

  • @martintatlock8684
    @martintatlock8684 7 місяців тому

    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!

  • @danijeldz
    @danijeldz 7 місяців тому +1

    Spilled range is a big game changer🎉

    • @sarth7649
      @sarth7649 7 місяців тому +1

      I recently had to create a matrix for some qc and just ended up creating a couple of helper columns. But spilled range is definitely so much better!

    • @LeilaGharani
      @LeilaGharani  7 місяців тому

      It sure is!

  • @humbalapa
    @humbalapa 6 місяців тому

    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!

  • @danilodolabela5247
    @danilodolabela5247 7 місяців тому

    This is superb, the way you explain is clear to understand and replicate, you have a gift, and it's been years since I've been following your work on UA-cam, and getting better at my job by applying all the knowledge you shared, thank you so much! Keep it up with this amazing work.

    • @LeilaGharani
      @LeilaGharani  7 місяців тому +1

      I really appreciate the kind words. Thank you for your support over the years!

  • @SunilPatil-ee1ff
    @SunilPatil-ee1ff 7 місяців тому +1

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

  • @amyw4816
    @amyw4816 2 місяці тому

    impressed!!! more vids like this please, it's so unique and inspirational!

  • @TehHyphen
    @TehHyphen 7 місяців тому +1

    I would like to add that if you hold down Shift while clicking and dragging an object, it will lock movement to the orthogonal directions only. You can use this in combination with holding Ctrl as shown in the video (3:35) to make a copy of the object that is strictly aligned with the original, to keep them all in line.
    Alternatively, you can use the Align objects feature from the Shape Format ribbon tab.

  • @giryilham5892
    @giryilham5892 5 місяців тому

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

    • @LeilaGharani
      @LeilaGharani  5 місяців тому

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

  • @jessicaykeith
    @jessicaykeith 5 місяців тому

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

  • @WaqasAli-dq9wg
    @WaqasAli-dq9wg 7 місяців тому +1

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

  • @jihadalbustanji3760
    @jihadalbustanji3760 7 місяців тому

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

  • @shashankshekhar4441
    @shashankshekhar4441 7 місяців тому

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

  • @chrism9037
    @chrism9037 7 місяців тому +2

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

  • @etutorshop
    @etutorshop 6 місяців тому

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

  • @MJWinters
    @MJWinters 7 місяців тому

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

  • @robertgutierrezrodriguez9646
    @robertgutierrezrodriguez9646 7 місяців тому

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

  • @tabassum7823
    @tabassum7823 5 місяців тому

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

  • @lea-kc
    @lea-kc 7 місяців тому

    Can’t express how great this is! 😍📊

  • @MichelleKC.
    @MichelleKC. 5 місяців тому

    Clear, concise and well explained. Thank you.

  • @Czechbound
    @Czechbound 5 місяців тому

    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

  • @Sand379
    @Sand379 6 місяців тому +1

    Good

  • @MariaSaleem-gi4uj
    @MariaSaleem-gi4uj 7 місяців тому

    14:00 onward ..Wao..Xlookup can return objects...and it can spill down and across. Amazing

  • @rudiklein
    @rudiklein 7 місяців тому

    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.

  • @TheDigitalOne
    @TheDigitalOne 7 місяців тому

    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 6 місяців тому

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

  • @reulfah
    @reulfah 4 місяці тому

    Amazing as alwaysz thank you Leila! ❤

  • @tristangeoffroy9286
    @tristangeoffroy9286 7 місяців тому

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

  • @sushilexcel4966
    @sushilexcel4966 3 місяці тому

    Thank you for sharing amazing knowledge, really really very nice

  • @borstenpinsel
    @borstenpinsel 7 місяців тому +1

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

  • @JanetLee-g6d
    @JanetLee-g6d 7 місяців тому

    Another thumb up excel tutorial! Thank you Leila

  • @apoorvagala
    @apoorvagala 7 місяців тому

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

  • @hennter
    @hennter 7 місяців тому +1

    Beautiful charts 😊 However, if the table source for the first chart gets a new category the text box approach would not be dynamic. Could you show us, how you would make that chart dynamic instead of using text boxes? Love your work btw!

    • @AlanLamb2024
      @AlanLamb2024 7 місяців тому

      I also wanted Chart 1 to be dynamic.
      Hoped I'd find a solution in the comments, but no solution found.
      So decided to solve for a dynamic Chart 1 and share my solution. Please find key steps in my comments above.

  • @andrew7586
    @andrew7586 7 місяців тому

    On the first chart, the thing that isn't being captured (though just a case of adding a border to the bars) is the thin white dividing line between the bars which is a nice style element of the original.

  • @josecarlosgoncalves5065
    @josecarlosgoncalves5065 7 місяців тому

    Awesome content, been learning so much with your content!

  • @arbazahmad7177
    @arbazahmad7177 7 місяців тому

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

  • @paulboot4987
    @paulboot4987 7 місяців тому

    Great presentation - and thinkcell is indeed a relevant recommendation. Saved me so many hours (read : days) when I was a consultant…

  • @marylandcarvajal9909
    @marylandcarvajal9909 2 місяці тому

    Wow, it was extremely amazing! ❤🎉

  • @Jojo-gf5qb
    @Jojo-gf5qb 7 місяців тому +1

    Today I learnt, we can lookup picture in cell and the use of & instead of creating a column and use concat function for lookup.

  • @ihsanmalik9773
    @ihsanmalik9773 7 місяців тому

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

  • @Dwavard
    @Dwavard 7 місяців тому

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

  • @solowswan3447
    @solowswan3447 4 дні тому

    Very nice!! Could you make a story telling series of videos please?

  • @MrToughEnough
    @MrToughEnough 7 місяців тому

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

  • @michelleclayton1025
    @michelleclayton1025 7 місяців тому

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

  • @Saad-Sadiq
    @Saad-Sadiq 7 місяців тому

    Ramadan Mubarak Leila and happy to see you back.

  • @khjkjh651
    @khjkjh651 7 місяців тому

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

  • @toddlee933
    @toddlee933 6 місяців тому

    Wow, you make it look so easy!

  • @RajeshBhonkiyaTrainer
    @RajeshBhonkiyaTrainer 7 місяців тому

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

  • @Rice0987
    @Rice0987 7 місяців тому +1

    In my blank, i've made category labels like list from a range, and stretched it along chart.😊

  • @diarimachan
    @diarimachan 5 місяців тому

    Thank you. Just what I need

  • @manoharmunipalli6146
    @manoharmunipalli6146 7 місяців тому

    Seriously super cool, thanks Leila

  • @graytonw5238
    @graytonw5238 4 місяці тому

    Okay, I followed the first chart without a problem, but that second chart was just plain frikkin' sorcery!

  • @Atiffan2
    @Atiffan2 7 місяців тому

    Wow! So Awesome! ❤ I have been trying to figure workaround to do this!