Progress Circle Chart in Excel as NEVER seen before!
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Learn how to create a stunning doughnut chart in Excel with this easy-to-follow video. Whether you're an Excel beginner or a seasoned user, you'll find valuable tips to enhance your charts.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/progress-ci...
Two Unique Methods: Discover not one, but two methods to create doughnut charts with smooth, rounded edges. Both methods are explained in detail, ensuring you can follow along regardless of your Excel experience.
Step-by-Step Guide: The video walks you through the entire process, from setting up your data to fine-tuning the visual details of your chart.
You'll learn how to:
▪️ Input and prepare data for the chart
▪️ Insert and adjust a doughnut chart
▪️ Customize with colors and titles
▪️ Embed additional information within your chart
This Progress circle chart infographic is different to what you've seen before.
Just like the other progress circle charts it uses the doughnut chart as the basis. A text box is placed in the middle of the progress chart (I will show you an Excel chart trick to embed the text box inside the chart object). The value of the text box is connected to the percentage completed value which is input in a cell.
00:00 How to Create a Professional Doughnut Chart in Excel
00:42 Progress Circle Chart Version Leila
04:57 Progress Circle Chart Version Sam
10:00 Wrap Up
What makes this chart different to the rest?
It's a small design tweak that makes THIS progress circle chart look more professional. This chart comes with ROUNDED EDGES. This seems like a small tweak, but there isn't a simple option in Excel to get the inside shape have rounded edges. In this video you'll find two versions to create this Excel progress chart infographic with rounded edges (or the doughnut chart with rounded edges):
Version #1 (by me) - It requires a simple tweak to the border of the chart. This brings us halfway there but it doesn't give the professional look we're going after.
Version #2 (by Sam Dekoven): This version has perfectly rounded edges for the doughnut chart and it uses a smart technique which combines a scatter plot series with the doughnut chart (together with the SIN COS and PI Excel Functions). Many thanks to Sam for sharing his version with all of us!
LINKS to Excel infographic chart playlist: • Excel Infographic Char...
Advanced Chart Techniques: • Excel Charts
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
Пікірлер: 608
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. ;-)
@LeilaGharani
4 жыл бұрын
It's always good to have something up your sleeve just in case :)
@CNYCNY1
4 жыл бұрын
Agree. My poor brain was hurting
@bttime1060
4 жыл бұрын
😂😂😂. I was thinking the same too
@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)
Omg!! A big shout out to Sam 👏🏼👏🏼
@LeilaGharani
Ай бұрын
👍
Your every single lecture is always awesome..!!! Especially Chart tutorial, is always wonderful.
Beautiful Charts, Leila!!! Thanks, Teammate!
@LeilaGharani
4 жыл бұрын
Thank you Teammate Mike!
That's impressive use of cos and sin functions.
@IIbarberII
3 жыл бұрын
finally jeje
We are very much grateful Leila. God richly bless you
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
4 жыл бұрын
Thank you very much! I feel special today :)
@galavdani6684
4 жыл бұрын
Mam.. plz make an elaborative tutorial on how to coustomize index on advanced level in Excel ... It will be great support to everyone..
That was amazing both solutions, and sam's was simply...brilliant
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!
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
4 жыл бұрын
You are very welcome. Glad you like our little circle chart fun :)
After watching this my excel skills went down to 0.0001%
@walerij
4 жыл бұрын
😄😄😄😄😄👍👍👍
@benf5610
3 жыл бұрын
🤣🤣🤣
@gulrajbhullar5525
2 жыл бұрын
we are in the same boat... mine is probably even smaller lol
@ahmedabbas569
2 жыл бұрын
😅😅
This is amazing, thank you for sharing both versions!
Sam is pretty GENIUS! Thanks Leila for sharing it.
@LeilaGharani
4 жыл бұрын
It sure is :)
Thanks Leila you always Queen of Excel
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.
Bless you for sharing these amazing excel tips.
Well done, as always Leila. Keep 'em coming!
@LeilaGharani
4 жыл бұрын
I'll try my best :)
Beautiful Leila. Great charts too!
Hi Leila, A real beauty! Easy to understand and reproduce! Thank you :-)
I love 😍 excel because of you, your work is incredible thank you so much
Second one is amazing...too good and professional version. Bang on
Great tips Leila & Sam!
You are great Leila!
Thanks Leila and Sam... great tutorial
Simply awesome. This adds flavor to visualizations in Excel like an infographic. 🤓
That was very satisfying! Sam's method is gold...I would never have thought of that!
@LeilaGharani
3 жыл бұрын
Thank you! Cheers!
Thanks to Leila , it solves my puzzle in years
Thank you for a very good and clear video. I appreciate that you have made the work available in Excel for downloading.
Very elegant chart :-), thank you for this Leila.
@LeilaGharani
4 жыл бұрын
My pleasure Nico. Glad you like it.
Thanks Leila, you are great!!!
Both versions are very creative - nice!!
Your videos are always creative and innovative ☺👍
Ms. Leila, having learnt a lot from your videos, I wish you a Happy TEACHERS Day, Thank you.
@LeilaGharani
4 жыл бұрын
Thank you very much. I feel special today :)
Your version is just fine for most of the cases!! 👍 Thx a lot!!!
Truly elegant solution.
Version 1 is just cool. Thanks Leila
This is so amazing!
Leila you are the best, and Sam's solution is so creative an innovative, thanks guys!
@LeilaGharani
4 жыл бұрын
Our pleasure!
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
Thank you so much my master Leila👍
amazing Leila, thank you very much, both ideas are great
That was REALLY good 👌"Thank You", thank you very much for sharing your support and time 😉
@LeilaGharani
4 жыл бұрын
Glad you enjoyed it
Great, beautiful graph!
Marvellous ideas ....Hats off to u and mr.sam....
That's. genius. Thanks for posting.
@LeilaGharani
4 жыл бұрын
Glad you like our little circle fun Sam :)
Both are cool - kudos to both of you!
Amazing. I was searching something like this. Thank you leila.
@LeilaGharani
4 жыл бұрын
Glad you found something here. Hope it helps.
You are AWESOME!!! EXACTLY what I was looking for.
I would never think of using sin and cos functions. This is great. Thank you for sharing!!!!!
@LeilaGharani
4 жыл бұрын
Same here. Sam's version is genius!
You are unbelievable, I'm really impressed
Thank you. Your videos are always awesome and great help for me
Thank you Leila for the great sharing! I can use this in my tutorial.
speechless!! wonderful trick.
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
4 жыл бұрын
Thank you! That's great to hear.
Votre solution graphique donne à tous les tableaux de bord une touche brillante, c'est vraiment professionnel... Thumbs up !
@LeilaGharani
4 жыл бұрын
Glad you like our little circle fun Reda :)
They're both excellent
really cool. smart job Sam!
Great work
Both! Awesome solution Sam!
I never thought of using pie charts for making circle progress indicators. I love this. Thanks!
@LeilaGharani
4 жыл бұрын
Food for thought Luciano :)
Wow you are taking excel to different level
Great video and explanation!
This tutorial really helps me very much, I've learned new ideas and knowledge by following the lesson. thank you.
@LeilaGharani
3 жыл бұрын
You're very welcome!
The first method gets the job done; the second method is simply brilliant!
Sine, Cosine? You mean there's actually a practical use for this????? I should have paid more attention in school.
@LeilaGharani
4 жыл бұрын
That's exactly what I thought 🤭
@ArnabAnimeshDas
4 жыл бұрын
Anywhere you see things are moving in a circle, you can use trigonometric functions to solve problems easily.
@ahmedalmubarak6612
4 жыл бұрын
Lol
@christiangeiselmann
4 жыл бұрын
The world is full of circles.
@walerij
4 жыл бұрын
Ha, really if they only had have told it me at school! They do not tell it us in all countries! 😄😄
Leila You are great !
Thanks! All your videos teach me a bunch.
@LeilaGharani
4 жыл бұрын
That's good to hear Victor.
This is a cool hack. I enjoy any video that helps me learn something new in Excel. Thank you for posting this video.
@LeilaGharani
4 жыл бұрын
My pleasure. Glad to help.
So helpful. Thank you.
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
4 жыл бұрын
That's great to hear! Thank you for your support.
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
4 жыл бұрын
Haha, maybe we went a bit overboard. But it was a fun challenge :)
@GustavoSoares
2 жыл бұрын
It all depends on how many times one plans to reuse it.
Good work Sam, that's the good one👌
SO HELPFUL!!
Thanks for your hard work to bring for us a very useful functions , really it help us to create professional reports & dashboards
Taking the edge off ! Mind blown
Great Video Liela
How remarkable! Just creative.
thanks for this video , really amazing
nice tutorial. good job. thanks
Ma'am Happy Teacher's Day!! Wish you all the love & Happiness in you life!!!
@LeilaGharani
4 жыл бұрын
Thank you very much!
Wow it’s great video. Thank you very much.
Thank you. I totally have a use for this!
that was very good!
Very clever. Congratulation.
Thank You so Much Beautiful Leila...
Thank you for the video, and to Sam for the solution V2, it's really impressed.
@LeilaGharani
4 жыл бұрын
Our pleasure :)
@liviasantos3253
3 жыл бұрын
Eu concordo. Parabens Sam - magical !
Beautiful, Lelia your my best excel teacher..Happy teacher day...
@LeilaGharani
4 жыл бұрын
Thank you!
Simply genius
All courses are wonderful 🧡
@LeilaGharani
3 жыл бұрын
Glad you think so!
Happy teachers day Leila. You are my favorite teacher. Video is excellent. I like Sams version.
@LeilaGharani
4 жыл бұрын
Thank you! Sam's version is genius.
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
3 жыл бұрын
Thanks for sharing!
u'r the best, Leila
thanks a lot Leila, i am really improve my experience with your videos Thanks Leila "excel QUEEN"
@LeilaGharani
4 жыл бұрын
I'm glad to hear that :)
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
4 жыл бұрын
Sam's is really a genius solution :)
Great example!!!
Crazy idea. Thanks a lot 👍
@LeilaGharani
Жыл бұрын
Most welcome 😊
Nice work Thnx
Thanks for your teaching.. I learn Mony things...
Thank you very much for your continuous efforts...
@LeilaGharani
4 жыл бұрын
My pleasure. Always nice to see your comments.