Progress Circle Chart in Excel as NEVER seen before!

  Рет қаралды 683,134

Leila Gharani

Leila Gharani

Күн бұрын

Пікірлер: 614
@LeilaGharani
@LeilaGharani 11 ай бұрын
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 жыл бұрын
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 жыл бұрын
It's always good to have something up your sleeve just in case :)
@CNYCNY1
@CNYCNY1 5 жыл бұрын
Agree. My poor brain was hurting
@bttime1060
@bttime1060 4 жыл бұрын
😂😂😂. I was thinking the same too
@eduardpartenie3033
@eduardpartenie3033 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)
@galavdani6684
@galavdani6684 5 жыл бұрын
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 жыл бұрын
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..
@gintomino4136
@gintomino4136 5 жыл бұрын
That's impressive use of cos and sin functions.
@IIbarberII
@IIbarberII 3 жыл бұрын
finally jeje
@MrsCathT
@MrsCathT 5 жыл бұрын
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 :)
@Oppadu
@Oppadu 5 жыл бұрын
Your every single lecture is always awesome..!!! Especially Chart tutorial, is always wonderful.
@merbouni
@merbouni 5 жыл бұрын
Votre solution graphique donne à tous les tableaux de bord une touche brillante, c'est vraiment professionnel... Thumbs up !
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Glad you like our little circle fun Reda :)
@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. 🙂
@LeilaGharani
@LeilaGharani Ай бұрын
Thank you! 😃
@MosheMayefsky
@MosheMayefsky 2 жыл бұрын
The first method gets the job done; the second method is simply brilliant!
@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 :)
@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.
@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.
@excelisfun
@excelisfun 5 жыл бұрын
Beautiful Charts, Leila!!! Thanks, Teammate!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Thank you Teammate Mike!
@bluefishhh
@bluefishhh 3 жыл бұрын
That was very satisfying! Sam's method is gold...I would never have thought of that!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Thank you! Cheers!
@converti76
@converti76 4 жыл бұрын
Leila you are the best, and Sam's solution is so creative an innovative, thanks guys!
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Our pleasure!
@swastik9872
@swastik9872 5 жыл бұрын
Sam is pretty GENIUS! Thanks Leila for sharing it.
@LeilaGharani
@LeilaGharani 5 жыл бұрын
It sure is :)
@georgetosounidis5545
@georgetosounidis5545 5 жыл бұрын
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 жыл бұрын
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! :)
@christ6874
@christ6874 3 жыл бұрын
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!
@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.
@saharamh5905
@saharamh5905 7 ай бұрын
Omg!! A big shout out to Sam 👏🏼👏🏼
@LeilaGharani
@LeilaGharani 7 ай бұрын
👍
@el-rayjapheth6287
@el-rayjapheth6287 2 ай бұрын
I give it to you, Laila! You are good at what you do!
@JohnYoga
@JohnYoga 10 ай бұрын
Hi Leila, Is there a more elegant/simpler way of doing Part II now that we are four years later?
@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.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
😊
@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 :)
@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.
@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
@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!
@rpeary5043
@rpeary5043 3 жыл бұрын
This is just beyond clever. And I find it scary I fully understand all the theory of making it work.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Glad to hear that :)
@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!
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Thanks for sharing!
@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.
@septimusseverus252
@septimusseverus252 3 жыл бұрын
That was amazing both solutions, and sam's was simply...brilliant
@lpanebr
@lpanebr 5 жыл бұрын
I never thought of using pie charts for making circle progress indicators. I love this. Thanks!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Food for thought Luciano :)
@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!
@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.
@Auday365
@Auday365 5 жыл бұрын
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 жыл бұрын
Me too. I would've never been able to come up with such a solution.
@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!!
@stevensondioni7228
@stevensondioni7228 3 жыл бұрын
This tutorial really helps me very much, I've learned new ideas and knowledge by following the lesson. thank you.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
You're very welcome!
@GuruVideoAC
@GuruVideoAC 3 жыл бұрын
Wow you are taking excel to different level
@leonwhite490
@leonwhite490 5 жыл бұрын
Sine, Cosine? You mean there's actually a practical use for this????? I should have paid more attention in school.
@LeilaGharani
@LeilaGharani 5 жыл бұрын
That's exactly what I thought 🤭
@ArnabAnimeshDas
@ArnabAnimeshDas 5 жыл бұрын
Anywhere you see things are moving in a circle, you can use trigonometric functions to solve problems easily.
@ahmedalmubarak6612
@ahmedalmubarak6612 5 жыл бұрын
Lol
@christiangeiselmann
@christiangeiselmann 5 жыл бұрын
The world is full of circles.
@walerij
@walerij 4 жыл бұрын
Ha, really if they only had have told it me at school! They do not tell it us in all countries! 😄😄
@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.
@sandipraa
@sandipraa 5 жыл бұрын
Ma'am Happy Teacher's Day!! Wish you all the love & Happiness in you life!!!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Thank you very much!
@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 :)
@aftabhameedkhan9213
@aftabhameedkhan9213 5 жыл бұрын
Hi Leila! Brilliant as usual and kudos to Sam for the wonderful idea. I will use it in my reports and presentations. Looking forward to meeting you in Slovenia Excel Olympics! I hope I will get few mins of talk time with you. I am all set for Slovenia trip from Dubai. Take Care!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
That's great! Looking forward to seeing you there.
@aftabhameedkhan9213
@aftabhameedkhan9213 5 жыл бұрын
@@LeilaGharani Thank you and I am very eager to meet you! I hope you will note my name :)
@ronf28
@ronf28 2 жыл бұрын
Beautiful Leila. Great charts too!
@rogerhuston8287
@rogerhuston8287 5 жыл бұрын
How long has Excel been around? I'd have thought they would built this in by now as a line style or something.
@rdot21
@rdot21 3 жыл бұрын
for real. While this solution is brilliant it is more aptly an example of how horrendously behind Microsoft is in employing such a simple shape feature to their doughnut chart. This should be a one click solution for 'rounded edges' in the chart format page.
@robertakwasiadjei8223
@robertakwasiadjei8223 5 жыл бұрын
We are very much grateful Leila. God richly bless you
@farooqbadar2490
@farooqbadar2490 5 жыл бұрын
Hi Leila All your video are remarkably nice and worth trying . Thanks a lot.
@LeilaGharani
@LeilaGharani 5 жыл бұрын
I'm happy to hear that.
@JonnieR
@JonnieR 5 жыл бұрын
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 жыл бұрын
😅😅
@TheSingularitarian
@TheSingularitarian 5 жыл бұрын
Truly elegant solution.
@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.
@trewaldo
@trewaldo 4 жыл бұрын
Simply awesome. This adds flavor to visualizations in Excel like an infographic. 🤓
@phvaguiar
@phvaguiar 5 жыл бұрын
Microsoft developers should see this!
@Aniket2712
@Aniket2712 3 жыл бұрын
Yes it will be much more convenient than going through all this
@ngilsz3
@ngilsz3 4 жыл бұрын
All courses are wonderful 🧡
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Glad you think so!
@yanushcherkis2037
@yanushcherkis2037 4 жыл бұрын
Hello @ Leila Gharani. I am so grateful for your tutorials. Thank you so much for sharing your Excel wisdom with us. I've followed your instructions very carefully to get the same results. I am very close but it seems that my the Sin/Cos points are slightly off - looks like they are off by one/two pixels. I've tried to adjust the graph's size but I can't find a size where the end points (in Sam's example) are totally aligned with the rest of the progress bar. Do you have any suggestions? Thx!
@LauraMoncur
@LauraMoncur 7 ай бұрын
What an elegant solution!!
@LeilaGharani
@LeilaGharani 7 ай бұрын
Glad you like it!
@nls3081
@nls3081 3 жыл бұрын
Your version is just fine for most of the cases!! 👍 Thx a lot!!!
@davidferrick
@davidferrick 4 жыл бұрын
Wow!!! I love an aesthetically pleasing spreadsheet and I love technicality driving this but I could never see myself putting all this work into a progress donut. It's still very cool and I love when ideas are turned into challenges and then turned into solutions. THIS is a great example of obfuscation or as I like to say, there is complexity behind the simplicity.
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Haha, maybe we went a bit overboard. But it was a fun challenge :)
@GustavoSoares
@GustavoSoares 2 жыл бұрын
It all depends on how many times one plans to reuse it.
@voicefrominside1928
@voicefrominside1928 4 жыл бұрын
Marvellous ideas ....Hats off to u and mr.sam....
@مقدادحديد
@مقدادحديد 5 жыл бұрын
Thanks Leila you always Queen of Excel
@ganeshbhamare7
@ganeshbhamare7 5 жыл бұрын
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 жыл бұрын
Sam really created something great there.
@nevermind4780
@nevermind4780 5 жыл бұрын
Your videos are always creative and innovative ☺👍
@luqmanhadinorzafri1302
@luqmanhadinorzafri1302 3 жыл бұрын
Just like apple watch ring! Been searching for this hacks for ages. Thanks
@sarfarajkureshi6569
@sarfarajkureshi6569 5 жыл бұрын
Today indian people's celebrate teacher day, as you my excel techer I wish you happy techer day my dear mam,
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Thank you very much! We don't have that here so I appreciate it :)
@atiarana2217
@atiarana2217 4 жыл бұрын
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
@paulwaiswa3514
@paulwaiswa3514 3 жыл бұрын
Version 1 is just cool. Thanks Leila
@kgbadariprasad1
@kgbadariprasad1 4 жыл бұрын
I loved the 2nd way of representation. I have studied trigonometry, but never used practically. Could you please explain the Cos and Sin function used in the second method ??
@emilefirson6852
@emilefirson6852 3 жыл бұрын
I've apply for my dashboard report. I really thank for this 👍👍🙏
@VIJER47
@VIJER47 5 жыл бұрын
Thanks! All your videos teach me a bunch.
@LeilaGharani
@LeilaGharani 5 жыл бұрын
That's good to hear Victor.
@donychen2162
@donychen2162 5 жыл бұрын
Thanks to Leila , it solves my puzzle in years
@deouaahmadou8487
@deouaahmadou8487 2 жыл бұрын
Tu es très fortes et éloquente dans la communication, Merci beaucoup
@chanduhandsome9316
@chanduhandsome9316 5 жыл бұрын
Leila very helpful, i dont miss Thursday watching KZbin, because for your video
@LeilaGharani
@LeilaGharani 5 жыл бұрын
That makes me happy :)
@mmincredible1451
@mmincredible1451 5 жыл бұрын
Beautiful, Lelia your my best excel teacher..Happy teacher day...
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Thank you!
@dhananjaykansal8097
@dhananjaykansal8097 5 жыл бұрын
Oh yess... Lovely!!! Happy Teachers Day Leila Mam.
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Thank you very much!
@lcorcoran56
@lcorcoran56 5 жыл бұрын
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 жыл бұрын
Why no love for this solution??
@SergeLetunovskiy
@SergeLetunovskiy 3 жыл бұрын
Definitely liked version number two
@kamal265
@kamal265 4 жыл бұрын
Leila You are great !
@ahsahm
@ahsahm Жыл бұрын
You are AWESOME!!! EXACTLY what I was looking for.
@SuperZeeko
@SuperZeeko 5 жыл бұрын
You are great Leila!
@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
@09291975baku
@09291975baku Ай бұрын
Thanks for resolving my doubt , good.
@SeanMoran-byron67
@SeanMoran-byron67 3 жыл бұрын
Both! Awesome solution Sam!
@tabc6870
@tabc6870 5 ай бұрын
using the PI function is genius!
@wofdigy
@wofdigy 5 жыл бұрын
Well done, as always Leila. Keep 'em coming!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
I'll try my best :)
@sundergapuz8332
@sundergapuz8332 2 жыл бұрын
Thank you. Your videos are always awesome and great help for me
@lexhoge
@lexhoge 3 жыл бұрын
Both versions are very creative - nice!!
@DougHExcel
@DougHExcel 5 жыл бұрын
Great tips Leila & Sam!
@XCelVietnam
@XCelVietnam 2 жыл бұрын
amazing Leila, thank you very much, both ideas are great
@roselsimpson858
@roselsimpson858 5 жыл бұрын
Wow must be my lucky day 1st to comment great video as usual. Your videos are helping me with my job as an industrial engineer tremendously Thanks so much
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Thanks for the quick comment :) Glad the tutorials are helpful.
@mahdizamani8896
@mahdizamani8896 2 жыл бұрын
really cool. smart job Sam!
@JumpRopeVeteran
@JumpRopeVeteran 5 жыл бұрын
This is a cool hack. I enjoy any video that helps me learn something new in Excel. Thank you for posting this video.
@LeilaGharani
@LeilaGharani 5 жыл бұрын
My pleasure. Glad to help.
@towhidaferdousi4057
@towhidaferdousi4057 4 жыл бұрын
Taking the edge off ! Mind blown
@spktabpna
@spktabpna 5 жыл бұрын
Great video as usual. Can we use conditional formatting in that pie chart? Like red colour for below 20%, orange upto 80% and green above 80%?
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Yes - Create the data prep table with an If condition. So for example if we just have bad and good, then the bad series has this formula =IF(B2
@jericksonsalonga3257
@jericksonsalonga3257 5 жыл бұрын
@@LeilaGharani How about using 4 data for a single chart? A1 = value if below 20 A2 = value if 20 - 80 A3 = value if 80 - 100 A4 = remainder Example: If 19, then A1 = 19, A2 = 0, A3 = 0, A4 = 81 If 35, then A1 = 0, A2 = 35, A3 = 0, A4 = 65
@kkbutor
@kkbutor 3 жыл бұрын
@@LeilaGharani please make a video in that regard
@SteveSwanson999
@SteveSwanson999 4 жыл бұрын
Both are cool - kudos to both of you!
@kernoelnerd
@kernoelnerd 3 жыл бұрын
Really great solutions, both of them. Nevertheless , in order to become a little bit unpopular, Sam's one, to my opinion is not mathematically correct: As the center of the circles are put on the edges of the non-circle version, the resulting semi-circles reach into the area of the (1 - progress) part, such making the progress part optically larger than it really is ;-).
@vishalaggarwal487
@vishalaggarwal487 4 жыл бұрын
Second one is amazing...too good and professional version. Bang on
@foxbox7929
@foxbox7929 4 жыл бұрын
Thank you for making me look smart!
@LeilaGharani
@LeilaGharani 4 жыл бұрын
😁
@atiaabdelkader1905
@atiaabdelkader1905 5 жыл бұрын
I love 😍 excel because of you, your work is incredible thank you so much
@arunkumarnair001
@arunkumarnair001 5 жыл бұрын
Your excel tutorials are my go to when I am stuck up. Thank you so much for guiding me in my quest for better excel knowledge. I already have taken up your VBA course in udemy. :) Once again Thank you so much.
@LeilaGharani
@LeilaGharani 5 жыл бұрын
That's great to hear! Thank you for your support.
@hansamfotos
@hansamfotos 5 жыл бұрын
Sam's was sick! I almost spit out the water I am drinking when I saw the rounded edges after the setup! Sin/cos!!!! Ftw!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
😂
@GosCee
@GosCee 3 жыл бұрын
Wow! Thanks for sharing this, @Leila Gharani. Very nice! I am definitely going to use it 😊. Even though Mathematics was my favourite subject in school and I had loved the sine and cosine trigonometrical functions, I have never used them (are seen them used) in the real world (work) application - thanks, Sam.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Our pleasure :)
Five Tips for Optimal Excel Chart Design
5:15
Leila Gharani
Рет қаралды 75 М.
Infographics: Progress Circle Chart in Excel
12:29
PK: An Excel Expert
Рет қаралды 1,1 МЛН
Правильный подход к детям
00:18
Beatrise
Рет қаралды 11 МЛН
Une nouvelle voiture pour Noël 🥹
00:28
Nicocapone
Рет қаралды 9 МЛН
Make Beautiful Excel Charts Like The Economist (file included)
19:07
Leila Gharani
Рет қаралды 491 М.
How to Instantly Improve Your Excel Charts [Watch This!]
11:16
MyOnlineTrainingHub
Рет қаралды 36 М.
Build Awesome Excel Visuals to Grab Anyone's Attention
18:11
Kenji Explains
Рет қаралды 430 М.
Progress Chart With Pivot Table and Slicer
20:09
Excellent Dude
Рет қаралды 20 М.
How to WOW Your Boss: 3D Progress Circle in Excel 🚀
6:26
PK: An Excel Expert
Рет қаралды 18 М.
Fast & Easy! McKinsey Chart in Excel. Watch this...
10:38
Leila Gharani
Рет қаралды 246 М.
Правильный подход к детям
00:18
Beatrise
Рет қаралды 11 МЛН