Progress Circle Chart in Excel as NEVER seen before!

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

КОМЕНТАРІ • 614

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

    Create charts that wow your audience. Learn the secrets now-start today! 👉 link.xelplus.com/yt-g-donut-charts-course
    Grab the file I used in the video from here: pages.xelplus.com/progress-circle-chart-file

  • @mr.brownstone5716
    @mr.brownstone5716 5 років тому +269

    I could live a thousand life times and I never would have come up with Sam's solution. I'll never use this method but it's cool knowing it exists. ;-)

    • @LeilaGharani
      @LeilaGharani  5 років тому +12

      It's always good to have something up your sleeve just in case :)

    • @CNYCNY1
      @CNYCNY1 5 років тому +15

      Agree. My poor brain was hurting

    • @bttime1060
      @bttime1060 4 роки тому +1

      😂😂😂. I was thinking the same too

    • @eduardpartenie3033
      @eduardpartenie3033 3 роки тому +3

      Yes, the great uncle Sam.. :)) very informative, not sure why I spent more than 10 minutes of my life on this and I'm still smiling (maybe thinking of how creative people can be)

  • @gintomino4136
    @gintomino4136 5 років тому +83

    That's impressive use of cos and sin functions.

  • @galavdani6684
    @galavdani6684 5 років тому +49

    We are celebrating teachers day today in India and I want to wish you happy teachers day as I had learned some great stuff in excel from you .. 👍🏻

    • @LeilaGharani
      @LeilaGharani  5 років тому +4

      Thank you very much! I feel special today :)

    • @galavdani6684
      @galavdani6684 5 років тому

      Mam.. plz make an elaborative tutorial on how to coustomize index on advanced level in Excel ...
      It will be great support to everyone..

  • @Oppadu
    @Oppadu 5 років тому +7

    Your every single lecture is always awesome..!!! Especially Chart tutorial, is always wonderful.

  • @MrsCathT
    @MrsCathT 5 років тому +1

    Hi Leila, I like yours for its simplicity and Sam’s for its aesthetic. In the end both are impactful to show progress. Thank you for sharing!

    • @LeilaGharani
      @LeilaGharani  5 років тому

      You are very welcome. Glad you like our little circle chart fun :)

  • @excelisfun
    @excelisfun 5 років тому +26

    Beautiful Charts, Leila!!! Thanks, Teammate!

  • @merbouni
    @merbouni 5 років тому

    Votre solution graphique donne à tous les tableaux de bord une touche brillante, c'est vraiment professionnel... Thumbs up !

    • @LeilaGharani
      @LeilaGharani  5 років тому +1

      Glad you like our little circle fun Reda :)

  • @georgetosounidis5545
    @georgetosounidis5545 5 років тому +18

    Hi all,
    I believe the 2nd solution is adding half a circle's area to the completed ring to both ends (so a full circle) which changes the visual proportions. Better would be if the whole of the circular disk was inside the completed ring, with the circumference tangent to it.
    This may not be much of a problem if the completed percentage is high enough, but it does skew the visual info the graph is communicating.
    Also, if the completed percentage is small, like 1% or even 5%, this will certainly give the wrong picture to the audience. It will start to become apparent.
    In the case of small percentages, we risk the radious of the circle being to large to depict them. As such with this method we can show up to a certain minimum of completed percentage. I just saw this and i don't have the time to create and test it (02:50, here in the UK and i have to be in the office in 5 hours...) but if i had to guess i'd say it shows a full circular disk even at 0%.
    A better way to implement something like this would be to have ellipses at the end of the ring, where the a,b parameters would be dynamically linked to the completion percentage, with possibly an upper bound, to avoid extremes.
    The equation of an eclipse is (x^2/a^2) + (y^2/b^2) = r^2.
    a,b and r are given in squares for symmetry.
    For a=b we get a circle (the above equation becomes x^2 + y^2 = r^2*a^2 (or *b^2), which is basicaly x^2 + y^2 = R^2 (just a new r, as a,b are parameters).
    Can you please check what happens for 0% or 1% ?
    I feel the first solution is correct.

    • @TheAnimeist
      @TheAnimeist 3 роки тому +3

      It would have been nice to see the results of both methods at 99%, 98%, ..., etc. And then see at which % point does each method not have overlapping pixels.

    • @faucillon
      @faucillon Рік тому

      I agree, but given the series are provided through a calculation i feel like we can simply subtract the radius of the scatter plot markers to account for the difference.
      1 important thing though will be that one needs to add the removed radius back to the doughnut when the input value = 100%
      Otherwise my solution will give you a slight area where the grey is still showing although the percentage is 100%.
      I'll be using my adaptation of Sams solution here. Great work, thanks for sharing both! :)

  • @DataMastery360
    @DataMastery360 2 роки тому

    I didnt understand the sin & cos function, but one thing I know is that I used this method of creating the doughnut chart at my work, and this changed my life.
    Thank you Leila.

  • @MosheMayefsky
    @MosheMayefsky 2 роки тому

    The first method gets the job done; the second method is simply brilliant!

  • @converti76
    @converti76 4 роки тому

    Leila you are the best, and Sam's solution is so creative an innovative, thanks guys!

  • @saharamh5905
    @saharamh5905 7 місяців тому +4

    Omg!! A big shout out to Sam 👏🏼👏🏼

  • @dojinho
    @dojinho 5 років тому

    Kudos to Sam! I must humbly admit I would not have come up with this solution. But then again, I can't think of a situation where I would go through the trouble of making round edges!

    • @LeilaGharani
      @LeilaGharani  5 років тому

      Sam's is really a genius solution :)

  • @swastik9872
    @swastik9872 5 років тому

    Sam is pretty GENIUS! Thanks Leila for sharing it.

  • @el-rayjapheth6287
    @el-rayjapheth6287 2 місяці тому

    I give it to you, Laila! You are good at what you do!

  • @bluefishhh
    @bluefishhh 3 роки тому

    That was very satisfying! Sam's method is gold...I would never have thought of that!

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

    This is amazing. I was looking for this technique from last many months and not getting any hint. Thank you so much for sharing this.

  • @abdul-muhaimendalghusa7855
    @abdul-muhaimendalghusa7855 Місяць тому

    I thank you very much Leila. You are such an amazing teacher and I appreciate these lessons very much not many can afford these advanced courses and there you go giving us a snippets. Just know that you are appreciated. 🙂

  • @septimusseverus252
    @septimusseverus252 3 роки тому +2

    That was amazing both solutions, and sam's was simply...brilliant

  • @christ6874
    @christ6874 3 роки тому +31

    Thank you for sharing both versions. While I prefer the look of Sam’s version, I really doubt all that fine-tuning is going to have a significant impact on a business presentation. It brings to mind the law of diminishing returns. So for the sake of efficiency and effectiveness, I’d just use your version and spend more time on making the business case more attractive instead.

    • @luqmanshah7942
      @luqmanshah7942 Рік тому

      Couldn't agree more. Sometimes we get caught up in the small intricacies of our curiosity and imagination, but it can often hinder us from what's priority: which is just developing a presentable and easy to follow report/dashboard for decision making. That's it!

  • @joshuacoppersmith
    @joshuacoppersmith 4 роки тому

    I used to play with more mathy charting in Excel 2003 when we could do snappy dynamic charting from VBA. But then it slowed down with the shared charting between Word and Excel in 2007. This piques my interest in the mathy bits again. Thanks Sam and Leila!

  • @jonathanleok9880
    @jonathanleok9880 3 роки тому

    Now I understand why did we need to learn the sin, cos and tan functions in schools. So that one day we will stumble upon this video in this amazing channel.

  • @JonnieR
    @JonnieR 5 років тому +145

    After watching this my excel skills went down to 0.0001%

    • @walerij
      @walerij 4 роки тому

      😄😄😄😄😄👍👍👍

    • @benf5610
      @benf5610 4 роки тому

      🤣🤣🤣

    • @gulrajbhullar5525
      @gulrajbhullar5525 3 роки тому

      we are in the same boat... mine is probably even smaller lol

    • @ahmedabbas569
      @ahmedabbas569 3 роки тому

      😅😅

  • @coolag74
    @coolag74 5 років тому

    Fantastic...Felt that you are in front of me...Every VDO teaches me something new...You are in the top teachers' list...Happy Teachers' Day...

    • @LeilaGharani
      @LeilaGharani  5 років тому

      Thank you! That's great to hear.

  • @ronf28
    @ronf28 2 роки тому

    Beautiful Leila. Great charts too!

  • @hiufgterde
    @hiufgterde 5 років тому

    I tried this some months ago and it works great. It’s not really easy to change it afterwards so best to get your format in place the first time

  • @voicefrominside1928
    @voicefrominside1928 4 роки тому

    Marvellous ideas ....Hats off to u and mr.sam....

  • @darioserrati4069
    @darioserrati4069 Рік тому

    Hi Leila, I think I'm writing a bit late and other people might already have picked up on the issues with the second version.
    1) the markers and the textbox don't resize automatically . So, don't bother to size the circle until the very end.
    2) the formula calculating x and y are not stable either. They are affected by the size of the circle diameter. I extended the axis from -1.15/1.15 to -1.25/1.25 to have more leeway and then adjsted the circle to centre the markers. Perhaps, an expert mathematician could provide a dynamic formula?
    However, it's a very cool trick 😄 Looking forward to seeing you at the next Excel gathering in January.

  • @ngilsz3
    @ngilsz3 4 роки тому

    All courses are wonderful 🧡

  • @TheSingularitarian
    @TheSingularitarian 5 років тому +1

    Truly elegant solution.

  • @SeanMoran-byron67
    @SeanMoran-byron67 3 роки тому

    Both! Awesome solution Sam!

  • @MadsAlbertsen
    @MadsAlbertsen 5 років тому

    I like Sams solution the most, it is impressive, but would never make things that complicated in practical use, and definitely go for Leilas solution.

    • @LeilaGharani
      @LeilaGharani  5 років тому

      Sam's solution really is genius.

  • @Auday365
    @Auday365 5 років тому +2

    Sam's nice tweak solution is to
    - Add Start and End points as Filled Circles at a calculate points (Simple Trigonometry)
    - Fix the graph so the circles are plotted at expected points
    - Define the scale of each axis
    Personally i prefer the simpler solution but i am fascinated with the math.

    • @LeilaGharani
      @LeilaGharani  5 років тому +2

      Me too. I would've never been able to come up with such a solution.

  • @stefanogattoCH
    @stefanogattoCH 5 років тому

    Thank you for this Leila. Not that I need it, but pushing the limits further it's good habits anyway!

    • @LeilaGharani
      @LeilaGharani  5 років тому

      Exactly Stefano! Food for thought what is possible with Excel.

  • @GuruVideoAC
    @GuruVideoAC 3 роки тому

    Wow you are taking excel to different level

  • @phvaguiar
    @phvaguiar 5 років тому +41

    Microsoft developers should see this!

    • @Aniket2712
      @Aniket2712 3 роки тому

      Yes it will be much more convenient than going through all this

  • @nevermind4780
    @nevermind4780 5 років тому +2

    Your videos are always creative and innovative ☺👍

  • @JohnYoga
    @JohnYoga 10 місяців тому +1

    Hi Leila,
    Is there a more elegant/simpler way of doing Part II now that we are four years later?

  • @paulwaiswa3514
    @paulwaiswa3514 3 роки тому

    Version 1 is just cool. Thanks Leila

  • @mmaier58
    @mmaier58 4 роки тому

    Just wanted to let you know this post is amazing, and your library of topics makes you a genius in my non-mathematical mind :) And I echo many of the appreciative comments made below. Thanks much for your efforts!

  • @rina1592
    @rina1592 5 років тому

    Ms. Leila, having learnt a lot from your videos, I wish you a Happy TEACHERS Day, Thank you.

    • @LeilaGharani
      @LeilaGharani  5 років тому

      Thank you very much. I feel special today :)

  • @rpeary5043
    @rpeary5043 3 роки тому

    This is just beyond clever. And I find it scary I fully understand all the theory of making it work.

  • @مقدادحديد
    @مقدادحديد 5 років тому +1

    Thanks Leila you always Queen of Excel

  • @nls3081
    @nls3081 3 роки тому

    Your version is just fine for most of the cases!! 👍 Thx a lot!!!

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

    Thanks for resolving my doubt , good.

  • @deouaahmadou8487
    @deouaahmadou8487 2 роки тому

    Tu es très fortes et éloquente dans la communication, Merci beaucoup

  • @atiarana2217
    @atiarana2217 4 роки тому +2

    I LOVE EXCEL. BUT AS I STARTED TO ATTEND THESE LECTURES. I REALLY EXPERIENCED A DIFFERENT AND NEW KNOWLEDGE BASE ASPECTS OF EXCEL.
    I AM THANKFUL TO MAM LEILA GHRANI

  • @kamal265
    @kamal265 4 роки тому

    Leila You are great !

  • @SuperZeeko
    @SuperZeeko 5 років тому

    You are great Leila!

  • @mahdizamani8896
    @mahdizamani8896 2 роки тому

    really cool. smart job Sam!

  • @lpanebr
    @lpanebr 5 років тому

    I never thought of using pie charts for making circle progress indicators. I love this. Thanks!

  • @emilefirson6852
    @emilefirson6852 3 роки тому

    I've apply for my dashboard report. I really thank for this 👍👍🙏

  • @robertakwasiadjei8223
    @robertakwasiadjei8223 5 років тому

    We are very much grateful Leila. God richly bless you

  • @luqmanhadinorzafri1302
    @luqmanhadinorzafri1302 3 роки тому

    Just like apple watch ring! Been searching for this hacks for ages. Thanks

  • @VIJER47
    @VIJER47 5 років тому

    Thanks! All your videos teach me a bunch.

  • @ganeshbhamare7
    @ganeshbhamare7 5 років тому +1

    Thanks Leila,
    Version 1 take little efforts and time too.
    However the credit goes to Sam for rounded shape dynamic chart. ☺️
    Thank you both.

    • @LeilaGharani
      @LeilaGharani  5 років тому +3

      Sam really created something great there.

  • @farooqbadar2490
    @farooqbadar2490 5 років тому

    Hi Leila
    All your video are remarkably nice and worth trying .
    Thanks a lot.

  • @stevensondioni7228
    @stevensondioni7228 3 роки тому +1

    This tutorial really helps me very much, I've learned new ideas and knowledge by following the lesson. thank you.

  • @trewaldo
    @trewaldo 4 роки тому

    Simply awesome. This adds flavor to visualizations in Excel like an infographic. 🤓

  • @ahsahm
    @ahsahm Рік тому

    You are AWESOME!!! EXACTLY what I was looking for.

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

    What an elegant solution!!

  • @sarfarajkureshi6569
    @sarfarajkureshi6569 5 років тому +1

    Today indian people's celebrate teacher day, as you my excel techer I wish you happy techer day my dear mam,

    • @LeilaGharani
      @LeilaGharani  5 років тому +1

      Thank you very much! We don't have that here so I appreciate it :)

  • @ritheshkumarparemmal9400
    @ritheshkumarparemmal9400 5 років тому

    Happy teachers day Leila. You are my favorite teacher. Video is excellent. I like Sams version.

    • @LeilaGharani
      @LeilaGharani  5 років тому

      Thank you! Sam's version is genius.

  • @lexhoge
    @lexhoge 3 роки тому

    Both versions are very creative - nice!!

  • @sandipraa
    @sandipraa 5 років тому

    Ma'am Happy Teacher's Day!! Wish you all the love & Happiness in you life!!!

  • @proxperties4986
    @proxperties4986 3 роки тому

    The second method got me thinking, I really wanted to understand the mathematical concept behind it. So, I created a video and uploaded it on my channel explaining that, the method I used is slightly different than the one explained here, but it has the same output. I would really appreciate your feedback on that if possible.
    By the way, I’m a big fan of your content, I have been watching your videos since a very very long time, I learned a lot from you and now I’m teaching Excel online and offline. So Thanks again for your great content and effort.
    All the best to come!!

  • @bluesage1528
    @bluesage1528 5 років тому

    I would never think of using sin and cos functions. This is great. Thank you for sharing!!!!!

    • @LeilaGharani
      @LeilaGharani  5 років тому

      Same here. Sam's version is genius!

  • @VSP4591
    @VSP4591 4 роки тому

    Very clever. Congratulation.

  • @donychen2162
    @donychen2162 5 років тому

    Thanks to Leila , it solves my puzzle in years

  • @SteveSwanson999
    @SteveSwanson999 4 роки тому

    Both are cool - kudos to both of you!

  • @mmincredible1451
    @mmincredible1451 5 років тому

    Beautiful, Lelia your my best excel teacher..Happy teacher day...

  • @towhidaferdousi4057
    @towhidaferdousi4057 4 роки тому

    Taking the edge off ! Mind blown

  • @marcusnikander4535
    @marcusnikander4535 2 роки тому

    Thank you for a very good and clear video. I appreciate that you have made the work available in Excel for downloading.

  • @MyRobin38
    @MyRobin38 3 роки тому

    They're both excellent

  • @samcathcart5388
    @samcathcart5388 5 років тому +8

    That's. genius. Thanks for posting.

    • @LeilaGharani
      @LeilaGharani  5 років тому +1

      Glad you like our little circle fun Sam :)

  • @atiaabdelkader1905
    @atiaabdelkader1905 5 років тому +1

    I love 😍 excel because of you, your work is incredible thank you so much

  • @sundergapuz8332
    @sundergapuz8332 2 роки тому

    Thank you. Your videos are always awesome and great help for me

  • @dhananjaykansal8097
    @dhananjaykansal8097 5 років тому

    Oh yess... Lovely!!!
    Happy Teachers Day Leila Mam.

  • @chanduhandsome9316
    @chanduhandsome9316 5 років тому

    Leila very helpful, i dont miss Thursday watching UA-cam, because for your video

  • @SenthilvelMurugesan
    @SenthilvelMurugesan 4 роки тому

    Sam is the clear Winner here :) Loved both versions, though complex the Sams' is better, Thanks for Sharing Leila

    • @LeilaGharani
      @LeilaGharani  4 роки тому

      Agreed, Sam's version is amazing :)

  • @DougHExcel
    @DougHExcel 5 років тому

    Great tips Leila & Sam!

  • @lcorcoran56
    @lcorcoran56 5 років тому +2

    Great video,
    I tested myself to see if I could come up with something else and this seems to work for me.
    if you group a small circle in a square the same size as the chart and then rotate it,
    multiply the % by 360 in a helper cell, and then use VBA
    Private Sub Worksheet_Change(ByVal Target As Range)
    With Sheet1
    .Shapes("Group 12").Rotation = Range("E6").Value
    End With
    End Sub

    • @charlesch3ng
      @charlesch3ng 5 років тому +1

      Why no love for this solution??

  • @XCelVietnam
    @XCelVietnam 2 роки тому

    amazing Leila, thank you very much, both ideas are great

  • @SergeLetunovskiy
    @SergeLetunovskiy 3 роки тому

    Definitely liked version number two

  • @pravinshingadia7337
    @pravinshingadia7337 5 років тому

    Great video and explanation!

  • @vishalaggarwal487
    @vishalaggarwal487 4 роки тому

    Second one is amazing...too good and professional version. Bang on

  • @razikahamed5370
    @razikahamed5370 4 роки тому

    Good class. May god bless you.

  • @adhamm5503
    @adhamm5503 4 роки тому

    How remarkable! Just creative.

  • @AdeKaryadi
    @AdeKaryadi 3 роки тому

    nice tutorial. good job. thanks

  • @sachinjadhav-ll2jv
    @sachinjadhav-ll2jv 2 роки тому

    Simply genius

  • @michellemcdade7016
    @michellemcdade7016 4 роки тому

    SO HELPFUL!!

  • @theenlightened1s
    @theenlightened1s 5 років тому

    Thanks Leila and Sam... great tutorial

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

    using the PI function is genius!

  • @foxbox7929
    @foxbox7929 4 роки тому

    Thank you for making me look smart!

  • @h4niali
    @h4niali 4 роки тому

    Thanks for your hard work to bring for us a very useful functions , really it help us to create professional reports & dashboards

  • @hozifaemadeldein6295
    @hozifaemadeldein6295 4 роки тому

    You are unbelievable, I'm really impressed

  • @walek2001
    @walek2001 5 років тому

    FAVORITE EXCEL VIDEO! THANKS

  • @wofdigy
    @wofdigy 5 років тому

    Well done, as always Leila. Keep 'em coming!

  • @FamilyLifeComC
    @FamilyLifeComC 5 років тому

    Thanks Leila, you are great!!!