Progress Circle Chart in Excel - Part 1 of 2

Подписаться 575 тыс.

Просмотров 394 тыс.

50% 1

Sign up for our Excel webinar, times added weekly: www.excelcampus.com/blueprint...
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.
DOWNLOAD the file: www.excelcampus.com/charts/pr...
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.
Watch Part 2 - • Progress Circle Chart ...
FREE video series on Pivot Table & Dashboards: • Introduction to Pivot ...

Хобби

Опубликовано:

22 мар 2017

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 148

@lisakarlson587 7 лет назад

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.

@jewelljohnson6826 6 лет назад

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

@valchampion 4 года назад

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

@kylerstevens2199 7 лет назад

This was a simple yet very informative video. Great job!

@danmatheson2339 6 лет назад

Thank you for a clear, concise presentation! I appreciate you sharing your knowledge!!

@knyteryderr 5 лет назад

Thank you. Like everyone said, simple, to the point!

@leratomoleko398 4 года назад

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

@argyrisdemetriou1508 7 лет назад

Thanks Jon!!!Excellent and simple tutoring!!

@markanthony7078 Год назад

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

@richardhayden5874 6 лет назад

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

@alexrosen8762 7 лет назад

Great tutorial. Easy to understand and fun!

@tmaioli 4 года назад

Great lesson, I'm loving my new dashboard I built from this lesson.

@joshuaschneck 3 года назад

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

@investinginyourlife3186 5 лет назад

Simple, easy to understand and perfect for my need. Thanks

@hantejudy 4 года назад

The conditional formatting information is pretty cool, thanks!

@zabethegolfer 5 лет назад

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

@Julieskvz 6 лет назад

I loved it. You explain very well and simple. Thank you!

@threethingsfour 6 лет назад

This was extremely helpful! Thanks for creating this content!

@abubakarisa3426 7 лет назад

Simple and to the point. I feel like going and grab a doughnut right away!!!

@origamichan 5 лет назад

Awesome! You taught me two things: 1) it's called a "doughnut chart," and 2) how to make one. Thank you!

@Voodootiger 6 лет назад

great job on the amazingly well structured and instructional videos!

@maximus380 6 лет назад

Excellent tutorial. I am tasked with creating charts and analyzing trends. This has been very helpful.

@sacshriv 7 лет назад

Brilliant work John... Absolutely great work as whole video was simple and easy to learn

@NohaTarab 7 лет назад

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

@juliakollekcreativeservice485 5 лет назад

Really great instructions & easy to follow, thank you!

@kimjacoby1443 2 года назад

Thank you for this concise and easy to follow video!

@08dayxday 5 лет назад

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

@edwardpadilla7543 5 лет назад

Great video. Simple and straight to the point.

@krismaly6300 7 лет назад

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!

@ExcelCampus 7 лет назад

Thank you Kris! :-)

@iragray4954 6 лет назад

Your making it happen. THANK YOU!!!

@skyegray3354 7 лет назад

Jon, i thank you for you tutorials

@allisonklopotek3699 6 лет назад

Thank you for making this easy to do!

@giorgiorossi2515 2 года назад

Intelligent and simple explanation .... Bravo!

@kimfucku8074 7 лет назад

Nice, clear and short. For more artistic designs you can use other shapes to contain the number as well.

@Ziva00 5 лет назад

This is great very thorough and easily understood. Thank you so much this is fantastic.

@subhraorhaw5551 7 лет назад

i really appreciate the way you explain

@nsanch0181 5 лет назад

This is very helpful. Thank you Jon.

@muritalaadebayoisah9155 5 лет назад

Thank you so much. I found this lesson very helpful.

@ThatPerson-qv7et 3 года назад

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

@jim8432 5 лет назад

Good information. I will be watching more of your videos. Thank You I have been subscribed for a while and learned a lot.

@80andromeda08 4 года назад

Amazing video and excellent lesson .. Thanks a lot Jon ❤

@JuanColosimo 6 лет назад

Great video! Was able to make it works for me, thank you!

@heathermonroe461 4 года назад

That helped so much! THANKS!

@garynere05 5 лет назад

Excellent video, very helpful, clearly explained

@eliezerhilario 7 лет назад

Muy buen video. Me ha sido de gran ayuda

@JohnsonKongor 6 лет назад

Nice practice. I really love it. Thanks so much.

@saaneroa5024 3 года назад

Great video. Very helpful for me. Thank you.

@Iam_Karyse 2 года назад

This was fairly easy. Thank you

@evelynmuir236 3 года назад

Thank you this was really helpful!

@joelcolon7605 6 лет назад

Super helpful, thank you Jon

@tamarathiessen2758 6 лет назад

Excellent Video!

@tobinpa1 4 года назад

Great tutorial, thank you

@mdfutbol Год назад

Great and Simple... thanks

@ebbzsweets3617 2 года назад

Love it. Thanks

@pallavisaini1509 6 лет назад

Best teacher. Cheers.

@muya65 4 года назад

thanks for this great video. very simple to follow :)

@marmarana 7 лет назад

Thanks for helping us

@Jewells666 3 года назад

Great video!! Appreciate this!

@ianbrown4914 6 лет назад

Good stuff, much appreciated

@TCliffordC Год назад

Great help. Thank!

@poppygold 5 лет назад

Quite useful, thanks!

@kbunkvet 2 года назад

Very helpful. Thank you

@gavinspeak3605 5 лет назад

Great simple explanation

@jrmanning25 6 лет назад

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

@narender879 6 лет назад

Nice and simple. Thanks

@ahmadalsaif1116 7 лет назад

Thank you very much:)

@mehulparmar7652 3 года назад

This was epic. Thanks.

@97grad 4 года назад

Easy to follow, thanks

@eng.mahmouda.mokhtar6561 3 года назад

Thanks for the doughnut fun!

@obdonkor 3 года назад

great video. thanks

@Mujcanal 6 лет назад

well explained, thank you

@franck777 4 месяца назад

Very clear and useful. Love it!

@ExcelCampus 4 месяца назад

Great to hear! 😀

@ZAHIDHUSSAIN-ri5kg 6 лет назад

Thanks John!

@sangeetasbhaktiandmotivati9215 6 лет назад

awesome video on progress circle chart......thanku sir

@malvinavartanian2203 7 лет назад

Great video.

@StudySessionYT 4 года назад

Awesome video Jon, thanks!!

@ExcelCampus 4 года назад

Glad you liked it! 👍

@amam964 6 лет назад

i really enjoyed.thanks alot.

@valentemorais2023 3 года назад

Fantastic. "Wow"

@TeknoGTI 6 лет назад

Wow! Awesome!

@chisamuel7168 7 лет назад

thank you was always trying to figure out how to creat a 🍩 chart. simple tips and easy to reproduce. thank you sir

@ExcelCampus 7 лет назад

Thank you Chi! :-)

@curiouscato8036 3 года назад

Thanks!

@doclina9137 4 года назад

many thanks

@czynsz 5 лет назад

Good Work!!

@obdonkor 3 года назад

great video

@nubiandawta8574 6 лет назад

Very helpful

@vikrampawar19 3 года назад

THANKS.. NICE VIDEO

@abdallah.kandiel 7 лет назад

thanks a lot very helpfull

@ThesweetEscape547 5 лет назад

great Job ! thx!

@eliedgecomb4903 2 года назад

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!