Progress Circle Chart in Excel as NEVER seen before!

preview_player
Показать описание

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.

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!

🚩Let’s connect on social:

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
Рекомендации по теме
Комментарии
Автор

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. ;-)

mr.brownstone
Автор

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. 🙂

abdul-muhaimendalghusa
Автор

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

galavdani
Автор

That's impressive use of cos and sin functions.

gintomino
Автор

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

merbouni
Автор

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!

MrsCathT
Автор

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

Oppadu
Автор

Beautiful Charts, Leila!!! Thanks, Teammate!

excelisfun
Автор

Sam is pretty GENIUS! Thanks Leila for sharing it.

swastik
Автор

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

bluefishhh
Автор

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!

dojinho
Автор

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.

deepakratnani
Автор

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

MosheMayefsky
Автор

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.

DataMastery
Автор

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

converti
Автор

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

el-rayjapheth
Автор

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

rpeary
Автор

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.

christ
Автор

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.

MadsAlbertsen
Автор

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

septimusseverus