Progress Circle Chart in Excel as NEVER seen before!

5 September 2019 Excel Infographic Chart TemplatesShow more

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!

⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-progress-circle-chart

LINKS to Excel infographic chart playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyw08u-MZm4ROnB3J0gRlsop

Advanced Chart Techniques: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyEj7oQkCf7TL9yQQWXbGOQ

★ My Online Excel Courses ► https://courses.xelplus.com

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

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!

#MsExcel #Excel #LeilaGharani