Progress Circle Chart in Excel - Part 1 of 2

Progress Circle Chart in Excel - Part 1 of 2

Excel Campus - Jon

7 лет назад

388,964 Просмотров

Ссылки и html тэги не поддерживаются


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

@alexchooo123
@alexchooo123 - 29.05.2023 11:19

Is there a way I can include the data in the actual pie chart, so it works out the dates automatically without having to hide remaining days column?

Ответить
@TCliffordC
@TCliffordC - 31.03.2023 11:52

Great help. Thank!

Ответить
@seanmanning4202
@seanmanning4202 - 05.02.2023 18:43

Clarity 💯

Ответить
@Angelo-vh3zk
@Angelo-vh3zk - 24.01.2023 21:24

Can you do this with a pivot table as source?

Ответить
@sanamerchant9427
@sanamerchant9427 - 26.12.2022 17:44

Helpful

Ответить
@markanthony7078
@markanthony7078 - 14.12.2022 14:06

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

Ответить
@mdfutbol
@mdfutbol - 18.11.2022 09:23

Great and Simple... thanks

Ответить
@V91210
@V91210 - 16.08.2022 23:17

This was so easy to follow, thank you so much! I want to visualize my savings progress to help me stay motivated. Is there a way that the actual can have multiple entries? Like for different times that I put more money aside, it can calculate the total? Thanks again.

Ответить
@Kevrow88
@Kevrow88 - 04.08.2022 22:13

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

Ответить
@kimjacoby1443
@kimjacoby1443 - 11.05.2022 15:48

Thank you for this concise and easy to follow video!

Ответить
@kbunkvet
@kbunkvet - 22.04.2022 00:01

Very helpful. Thank you

Ответить
@eliedgecomb4903
@eliedgecomb4903 - 20.04.2022 04:45

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!

Ответить
@coinmarketcharts7276
@coinmarketcharts7276 - 06.04.2022 11:50

Dear Excel Campus - Jon, is there any way i.e. that I do not have to calculate the remainder value, somehow I fetch it into the field of the Doughnut chart? In other words, I want to create a doughnut chart with a single cell reference i.e. 35%, and the other value is always understood to be 100%. Please reply. Thanks.

Ответить
@wararkacaalamka8102
@wararkacaalamka8102 - 02.02.2022 14:53

thank you

Ответить
@Iam_Karyse
@Iam_Karyse - 27.12.2021 04:54

This was fairly easy. Thank you

Ответить
@ebbzsweets3617
@ebbzsweets3617 - 12.10.2021 03:34

Love it. Thanks

Ответить
@giorgiorossi2515
@giorgiorossi2515 - 17.09.2021 13:24

Intelligent and simple explanation .... Bravo!

Ответить
@valentemorais2023
@valentemorais2023 - 18.08.2021 21:13

Fantastic. "Wow"

Ответить
@saaneroa5024
@saaneroa5024 - 27.07.2021 01:07

Great video. Very helpful for me. Thank you.

Ответить
@mehulparmar7652
@mehulparmar7652 - 01.07.2021 15:43

This was epic. Thanks.

Ответить
@v2srikb
@v2srikb - 25.05.2021 10:10

Thank you for sharing this, it's awesome. Would I be able to do a similar thing with values not calculated in percentage? Or a different target vs actual value. Lets say our target is 4.8, or on other cases 40%. Please guide me to a video that explains how to achieve it.

Ответить
@abuyaseenfathah
@abuyaseenfathah - 21.04.2021 10:38

great job

Ответить
@obdonkor
@obdonkor - 02.04.2021 22:29

great video. thanks

Ответить
@obdonkor
@obdonkor - 02.04.2021 22:28

great video

Ответить
@evelynmuir236
@evelynmuir236 - 30.03.2021 18:24

Thank you this was really helpful!

Ответить
@curiouscato8036
@curiouscato8036 - 07.01.2021 20:39

Thanks!

Ответить
@Jewells666
@Jewells666 - 15.12.2020 22:35

Great video!! Appreciate this!

Ответить
@eng.mahmouda.mokhtar6561
@eng.mahmouda.mokhtar6561 - 14.11.2020 00:35

Thanks for the doughnut fun!

Ответить
@cholosabido1623
@cholosabido1623 - 30.09.2020 14:17

adding the text box to show the percentage does not work if the values are coming from a pivot table. Any ideas how to fix it?

Ответить
@joshuaschneck
@joshuaschneck - 26.09.2020 20:34

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

Ответить
@ThatPerson-qv7et
@ThatPerson-qv7et - 21.09.2020 23:40

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

Ответить
@readhwolf
@readhwolf - 10.09.2020 04:33

Thank you so much , I have question what if I have barrel as you know not measured by 100% but something like 210 liters how can I visualize it ?
Thanks in advance

Ответить
@vikrampawar19
@vikrampawar19 - 04.09.2020 23:19

THANKS.. NICE VIDEO

Ответить
@StudySessionYT
@StudySessionYT - 18.08.2020 20:27

Awesome video Jon, thanks!!

Ответить
@hantejudy
@hantejudy - 01.08.2020 23:59

The conditional formatting information is pretty cool, thanks!

Ответить
@mmrabad8521
@mmrabad8521 - 22.05.2020 18:47

This is great. But for one of the chart I put together, it shows chart fully colored (like 100 %) even when its 95 %. For example X chart is 95 %, this value comes from other two doughnut charts Y and Z where Y is 100 % and Z is 90 %. I did Y%+Z%/2 which shows 95 % ideally for 5 % there should be a gap on doughnut chart, but in this case its not.

Ответить
@leratomoleko398
@leratomoleko398 - 04.05.2020 08:56

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

Ответить
@tmaioli
@tmaioli - 09.04.2020 04:33

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

Ответить
@valchampion
@valchampion - 19.03.2020 22:22

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

Ответить
@krishj8011
@krishj8011 - 04.02.2020 06:08

thanks...

Ответить
@barryivy2761
@barryivy2761 - 01.02.2020 00:49

How do you get a donut chart to depict if results are positive or negative?

Ответить
@doclina9137
@doclina9137 - 18.01.2020 19:58

many thanks

Ответить
@muya65
@muya65 - 31.12.2019 12:29

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

Ответить
@80andromeda08
@80andromeda08 - 28.12.2019 20:19

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

Ответить
@tobinpa1
@tobinpa1 - 07.12.2019 00:23

Great tutorial, thank you

Ответить
@ikhind
@ikhind - 23.11.2019 11:01

Thanks fo this video! I have a question how can we show progress over 100% for example 120% It shows like 80% in this charts. Thanks a lot in advance

Ответить
@97grad
@97grad - 17.11.2019 02:42

Easy to follow, thanks

Ответить
@muhammadiqbal-uy6qr
@muhammadiqbal-uy6qr - 14.11.2019 09:08

Nice

Ответить
@BothaNoel
@BothaNoel - 06.11.2019 19:10

Hello, thanks for the video. Do you have instructions to go with Google Drive Sheets? The Donut Chart works but I cant put the text box in the middle with the Percentage showing :(

Ответить
@heathermonroe461
@heathermonroe461 - 13.09.2019 19:28

That helped so much! THANKS!

Ответить