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)
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.
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.
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!
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.
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.
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! :)
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!
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.
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.
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!
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.
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!!
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 ;-).
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!
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
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
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.
I'm lost with the sin/cos functions because its have been a long time since the last time I used it, but its fun to know sam method, now , i will try to understand this and find another uses to it... thanks :)
I just tried it with the workbook. At 98% the circle is full but you can still see the dents from the rounded edges to indicate it's not 100%. Works slightly better on Leila's version.
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
Actually I find that using Chart Title in place of the Textbox to display the center text isnt too bad too. It optimizes the object space too. (And I just spent minutes trying to group the textbox and the chart to no avail, didnt know about the trick to select the chart area first before creating a textbox) Wow, both are very eye-opening. Who said trigonometry and geometry is useless after leaving school, lol!
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.
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.
That’s very cool! I’ve recently been using a donut chart and pie chart on different axis for velocity of improvement, but this does look really cool, I’m going to give it a go today!
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!
This is Mohamed Basith with u.. Mrs. Leila I tried both your and Sam's model of making the charts.... Your model is quite easier and reliable for wide range of percentage changes.... ( I have one correction for your method - For fill option solid line and color changing and you change the grey dougnut thickness as 7 & blue as 13. But during my try i use the blue color as 13 as per your advise and i try to adopt the grey color will almost equal to the thickness of the blue so i use thickness 10 for grey it looks pretty much same as sam's chart.) However, sam's method is quite intresting while looking the video but it will not be practical for the diverse users sheets...(which means sam's -1.15 & 1.15 axis range will no more applicable for all the excel sheets. hence it will applicable only for sam's excel sheet) rest is fine. Hope anticipate many useful videos like these session to enhance the power and efficiency of the excel software... Thank you both....
Wow... nothing wrong with using math in life but just to get a simple chart with rounded edges there has to be an easier way! I'd go with Leila's method and be satisfied that it's round enough lol, but honestly bravo for integrating sin/cos and pi into a chart!
Hi Leila.. great video and techniques! I like both.. yours for the relative simplicity of setup.. and it looks great, even though not perfectly rounded at the caps.. and Sam's because of the clever way he designed the solution using trigonometry and the perfectly rounded caps are certainly visually appealing.. no denying that fact. The analyst in me wants to understand all the math behind Sam's version, but I'd probably go to your version first to get work out the door since it is easier and quicker to set up and maintain. Thanks for showing both approaches. Always something new and interesting coming from you and your channel. Thumbs up!! PS - On your version, if you make the point width of the remainder the same as the percentage complete.. say 14 point each.. it looks pretty good too. The color differential makes the percentage complete stand out pretty well, as is. As you said.. either or.. depending on personal preference :))
@Alex Ooi Hi Alex.. thanks for your feedback. Been fooling around with this a bit.. re-learning my high school trig which was about 100 years ago.. haha!! Now I remember how to plot points on a circle, convert degrees to radians for cartesian coordinates, use SIN(), COS() and RADIANS() functions in EXCEL. All good learning. I like Leila's method for the clever but simple setup.. can crank that one out quickly and it looks good. I like Sam's method for the cool use of trig and clever plotting of the points at the stationary and leading edges of the variable doughnut part.. but.. it takes a little longer to set up and getting it perfect can take some trial and error. Both great methods.. all good stuff to learn and exercise the brain cells. Thumbs up!!
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.
Awesome stuff, Leila. I'll try your method. Immediately thought that it can be used for Dashboards or to visualize metrics. Is it possible to have the color be dynamic? I mean, let's say if the number is below 70%, The progress bar would be Red. And then if greater than or equal to 70% but less than 90%, it would be Yellow or Amber. If greater than of equal to 90%, it would be Green.
Once again, you got me out of breath. Really impressive must say I'm always astounded by way you illustrating things. I go with Sam version, why ? Simply because your explaination ease our practice. Thx
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 ??
![How to Instantly Improve Your Excel Charts [Watch This!]](http://i.ytimg.com/vi/TqBYfMxVTc4/mqdefault.jpg)
Grab the file I used in the video from here 👉 pages.xelplus.com/progress-circle-chart-file
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. ;-)
It's always good to have something up your sleeve just in case :)
Agree. My poor brain was hurting
😂😂😂. I was thinking the same too
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)
That's impressive use of cos and sin functions.
finally jeje
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 .. 👍🏻
Thank you very much! I feel special today :)
Mam.. plz make an elaborative tutorial on how to coustomize index on advanced level in Excel ...
It will be great support to everyone..
Omg!! A big shout out to Sam 👏🏼👏🏼
👍
Your every single lecture is always awesome..!!! Especially Chart tutorial, is always wonderful.
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.
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.
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!
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!
You are very welcome. Glad you like our little circle chart fun :)
Votre solution graphique donne à tous les tableaux de bord une touche brillante, c'est vraiment professionnel... Thumbs up !
Glad you like our little circle fun Reda :)
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.
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.
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! :)
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!
Sam's is really a genius solution :)
Beautiful Charts, Leila!!! Thanks, Teammate!
Thank you Teammate Mike!
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.
Me too. I would've never been able to come up with such a solution.
The first method gets the job done; the second method is simply brilliant!
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.
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!
Thanks for sharing!
After watching this my excel skills went down to 0.0001%
😄😄😄😄😄👍👍👍
🤣🤣🤣
we are in the same boat... mine is probably even smaller lol
😅😅
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.
😊
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...
Thank you! That's great to hear.
That was very satisfying! Sam's method is gold...I would never have thought of that!
Thank you! Cheers!
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
using the PI function is genius!
Sam is pretty GENIUS! Thanks Leila for sharing it.
It sure is :)
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!!
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.
Sam's solution really is genius.
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 ;-).
Today indian people's celebrate teacher day, as you my excel techer I wish you happy techer day my dear mam,
Thank you very much! We don't have that here so I appreciate it :)
That was amazing both solutions, and sam's was simply...brilliant
Ms. Leila, having learnt a lot from your videos, I wish you a Happy TEACHERS Day, Thank you.
Thank you very much. I feel special today :)
Leila you are the best, and Sam's solution is so creative an innovative, thanks guys!
Our pleasure!
Sine, Cosine? You mean there's actually a practical use for this????? I should have paid more attention in school.
That's exactly what I thought 🤭
Anywhere you see things are moving in a circle, you can use trigonometric functions to solve problems easily.
Lol
The world is full of circles.
Ha, really if they only had have told it me at school! They do not tell it us in all countries! 😄😄
This is just beyond clever. And I find it scary I fully understand all the theory of making it work.
Glad to hear that :)
Microsoft developers should see this!
Yes it will be much more convenient than going through all this
I never thought of using pie charts for making circle progress indicators. I love this. Thanks!
Food for thought Luciano :)
This tutorial really helps me very much, I've learned new ideas and knowledge by following the lesson. thank you.
You're very welcome!
I would never think of using sin and cos functions. This is great. Thank you for sharing!!!!!
Same here. Sam's version is genius!
Thank you for this Leila. Not that I need it, but pushing the limits further it's good habits anyway!
Exactly Stefano! Food for thought what is possible with Excel.
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!
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
Thanks Leila,
Version 1 take little efforts and time too.
However the credit goes to Sam for rounded shape dynamic chart. ☺️
Thank you both.
Sam really created something great there.
Ma'am Happy Teacher's Day!! Wish you all the love & Happiness in you life!!!
Thank you very much!
Omg.. this is so crazy… 😨😨😨😨😨 didn’t know such complexity behind it
Wow you are taking excel to different level
Tu es très fortes et éloquente dans la communication, Merci beaucoup
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
Why no love for this solution??
Truly elegant solution.
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.
Haha, maybe we went a bit overboard. But it was a fun challenge :)
It all depends on how many times one plans to reuse it.
Your videos are always creative and innovative ☺👍
Sam is the clear Winner here :) Loved both versions, though complex the Sams' is better, Thanks for Sharing Leila
Agreed, Sam's version is amazing :)
I'm lost with the sin/cos functions because its have been a long time since the last time I used it, but its fun to know sam method, now , i will try to understand this and find another uses to it... thanks :)
I still don't really understand it :)
Hi Leila,
Is there a more elegant/simpler way of doing Part II now that we are four years later?
I wonder if something like 98% would cover all the chart, since the endpoints are adding some extra area. I like Leila’s solution more:)
I just tried it with the workbook. At 98% the circle is full but you can still see the dents from the rounded edges to indicate it's not 100%. Works slightly better on Leila's version.
Well.. If you would like to be that precise, you can consider making the doughnut narrower
Could also just have the leading edge rounded off, and the starting edge a flat line (no point)
=98-2
What an elegant solution!!
Glad you like it!
Thank you for a very good and clear video. I appreciate that you have made the work available in Excel for downloading.
Happy teachers day Leila. You are my favorite teacher. Video is excellent. I like Sams version.
Thank you! Sam's version is genius.
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!
😂
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
Thanks for the quick comment :) Glad the tutorials are helpful.
Simply awesome. This adds flavor to visualizations in Excel like an infographic. 🤓
Just like apple watch ring! Been searching for this hacks for ages. Thanks
Actually I find that using Chart Title in place of the Textbox to display the center text isnt too bad too. It optimizes the object space too. (And I just spent minutes trying to group the textbox and the chart to no avail, didnt know about the trick to select the chart area first before creating a textbox)
Wow, both are very eye-opening. Who said trigonometry and geometry is useless after leaving school, lol!
Вы открываете для меня новые методы построения диаграмм и графиков :)
That's good to hear Denis :)
We are very much grateful Leila. God richly bless you
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.
Our pleasure :)
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.
That's great to hear! Thank you for your support.
That’s very cool! I’ve recently been using a donut chart and pie chart on different axis for velocity of improvement, but this does look really cool, I’m going to give it a go today!
That's great. Let us know how it went.
I've apply for my dashboard report. I really thank for this 👍👍🙏
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!
That's great! Looking forward to seeing you there.
@@LeilaGharani Thank you and I am very eager to meet you! I hope you will note my name :)
I love 😍 excel because of you, your work is incredible thank you so much
This is Mohamed Basith with u..
Mrs. Leila I tried both your and Sam's model of making the charts....
Your model is quite easier and reliable for wide range of percentage changes.... ( I have one correction for your method - For fill option solid line and color changing and you change the grey dougnut thickness as 7 & blue as 13. But during my try i use the blue color as 13 as per your advise and i try to adopt the grey color will almost equal to the thickness of the blue so i use thickness 10 for grey it looks pretty much same as sam's chart.)
However, sam's method is quite intresting while looking the video but it will not be practical for the diverse users sheets...(which means sam's -1.15 & 1.15 axis range will no more applicable for all the excel sheets. hence it will applicable only for sam's excel sheet) rest is fine.
Hope anticipate many useful videos like these session to enhance the power and efficiency of the excel software...
Thank you both....
Thanks for your hard work to bring for us a very useful functions , really it help us to create professional reports & dashboards
Wow... nothing wrong with using math in life but just to get a simple chart with rounded edges there has to be an easier way! I'd go with Leila's method and be satisfied that it's round enough lol, but honestly bravo for integrating sin/cos and pi into a chart!
Haha, yes it's taking it to another level.
Thanks you.. it help me to improve my chart visualization
Leila very helpful, i dont miss Thursday watching CZcams, because for your video
That makes me happy :)
Thank you so much ... I'm using it now in my project status report
Hi Leila.. great video and techniques! I like both.. yours for the relative simplicity of setup.. and it looks great, even though not perfectly rounded at the caps.. and Sam's because of the clever way he designed the solution using trigonometry and the perfectly rounded caps are certainly visually appealing.. no denying that fact. The analyst in me wants to understand all the math behind Sam's version, but I'd probably go to your version first to get work out the door since it is easier and quicker to set up and maintain. Thanks for showing both approaches. Always something new and interesting coming from you and your channel. Thumbs up!!
PS - On your version, if you make the point width of the remainder the same as the percentage complete.. say 14 point each.. it looks pretty good too. The color differential makes the percentage complete stand out pretty well, as is. As you said.. either or.. depending on personal preference :))
Thank you Wayne for your feedback. When I saw Sam’s version I was so impressed :)
@Alex Ooi Hi Alex.. thanks for your feedback. Been fooling around with this a bit.. re-learning my high school trig which was about 100 years ago.. haha!! Now I remember how to plot points on a circle, convert degrees to radians for cartesian coordinates, use SIN(), COS() and RADIANS() functions in EXCEL. All good learning. I like Leila's method for the clever but simple setup.. can crank that one out quickly and it looks good. I like Sam's method for the cool use of trig and clever plotting of the points at the stationary and leading edges of the variable doughnut part.. but.. it takes a little longer to set up and getting it perfect can take some trial and error. Both great methods.. all good stuff to learn and exercise the brain cells. Thumbs up!!
Definitely liked version number two
Both are great.
1st simple for many of us.
2nd advanced for more fancy reports.
Your version is just fine for most of the cases!! 👍 Thx a lot!!!
Beautiful, Lelia your my best excel teacher..Happy teacher day...
Thank you!
nice tutorial. good job. thanks
Thanks to Leila , it solves my puzzle in years
Simply genius
This is a cool hack. I enjoy any video that helps me learn something new in Excel. Thank you for posting this video.
My pleasure. Glad to help.
My goodness! I'm going to stick with Leila's version. Sam's version is great as well though!
Hi Leila
All your video are remarkably nice and worth trying .
Thanks a lot.
I'm happy to hear that.
I need to practice a lot. No easy at all to repro this demo but it's a great one
You can download the workbook from the link in the description :)
Thanks! All your videos teach me a bunch.
That's good to hear Victor.
Thanks Leila you always Queen of Excel
That's. genius. Thanks for posting.
Glad you like our little circle fun Sam :)
How long has Excel been around? I'd have thought they would built this in by now as a line style or something.
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.
Awesome stuff, Leila. I'll try your method. Immediately thought that it can be used for Dashboards or to visualize metrics.
Is it possible to have the color be dynamic? I mean, let's say if the number is below 70%, The progress bar would be Red. And then if greater than or equal to 70% but less than 90%, it would be Yellow or Amber. If greater than of equal to 90%, it would be Green.
Would conditional formatting solve this question?
Once again, you got me out of breath. Really impressive must say I'm always astounded by way you illustrating things. I go with Sam version, why ? Simply because your explaination ease our practice. Thx
Sam's version really is genius :)
All courses are wonderful 🧡
Glad you think so!
thanks a lot Leila, i am really improve my experience with your videos
Thanks Leila "excel QUEEN"
I'm glad to hear that :)
I love it. They are both great manipulations. But I think I would use Sam's.
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 ??
You are AWESOME!!! EXACTLY what I was looking for.
They're both excellent
Second one is amazing...too good and professional version. Bang on