Progress Circle Chart in Excel - Part 1 of 2

The progress circle (doughnut) chart displays the percentage of completion on a single metric. This is a simple chart that can be used in dashboards to show the progress towards a goal or target. It's basically a progress bar chart in the shape of a circle or doughnut.

In this first video, we look at how to create the progress doughnut chart in Excel. It is a simple chart that just requires 1 doughnut chart and a formula.

In part 2 of the video series, I explain how to apply conditional formatting to the chart so the color of the bar changes as the progress level changes.

[jewelljohnson]

I have followed several of your tutorials and they have been to the point and easy to follow...thanks for making this a great way to learn Excel

[joshuaschneck]

Thanks! Great video that teaches all you need to know to make a good doughnut progress chart in just a few moments

[NohaTarab]

Thanks a lot for sharing the video ! Please continue to share videos for designing professionally looking business charts.

[markanthony]

Thank you Jon with such wonderful explanations and resources. So much appreciated. God bless

[kimjacoby]

Thank you for this concise and easy to follow video!

[hantejudy]

The conditional formatting information is pretty cool, thanks!

[dayxday]

Dude! You put the jelly on the bottom shelf. Amazing!

[giorgiorossi]

Intelligent and simple explanation .... Bravo!

[lisakarlson]

Excel Campus is great! Jon makes learning fun and delivers the information at a great pace in a format that makes it easy to absorb.

[valchampion]

Wow! This was by far one of the easiest presentation and instructions I have ever seen. Thank you!

[zabethegolfer]

Very helpful - easy concept explained in a great way. Thanks Jon

[eliedgecomb]

This is very helpful. I’m looking for a simple way to show the team how close to our budget goals we are each day and what they would need to accomplish to meet them. If we have a bad day for example, how much do we need to accomplish the next day in order to make up for it. I find lots of charts that show year over year, but not as many that compare goal to actual. If you have others that fit into that category, feel free to point me to them ;-) and thank you!

[saaneroa]

Great video. Very helpful for me. Thank you.

[richardhayden]

Excellent step by step guide, clearly explained. Thank you John

[ThatPerson-qvet]

Helped me to do exactly what I wanted, thank you so much

[garynere]

Excellent video, very helpful, clearly explained

[krismaly]

I love this video.

One of the interesting feature of Excel one should know this functionality. There is a lots of uses of this chart and very familier in today's world of gagets

Thanks for educating the community and appreciate your volunteership.

Good Luck!

[Kevrow]

This was awesome and made simple. How would you do this with Count vs Percentages?

[jrmanning]

I never knew the tip on how to make a text box "live"! Thanks!

[leratomoleko]

Thank you for a clear demonstration. Exactly what I needed for my Report.