Progress Circle Chart with Conditional Formatting - Part 2 of 2

[@gdog556]

doughnut charts are so majestic

[@CraftByte-d7f]

Best progress / gauge chart video for excel on KZbin I could find. Thank you sir, great work

[@ExcelCampus]

You are welcome! 😀

[@victoralexander8455]

I have unsuccessfully tried progress doughnut charting before; this time because of your KZbin explanation I was successful.Thanks.

[@sargonkheedo]

Jon, truly your videos are great... it is just the way the presentation you do, it makes things easy to understand and follow. Thank you!!

[@withonestonechannel]

I come to this tutorial time and time again!

[@origamichan]

Thank you, Jon! Your instructions are so easy to follow! I've created a "cheat sheet" for myself with all of the formulas you typed in (I'm not that good with Excel, yet), and my team and I can put this to use right away. I don't know if it's a tip, but if you position the inside label where you want it, and then Ctrl-D to duplicate it, before connecting the label to another cell in the Data Series, you can line up the new label with the existing one. This way, as your results change, the labels won't look like they bounce around quite so much. Cheers!

[@ofilispeaks]

cool tip

[@krismaly6300]

I love this video. Another great video. This helps for reporting comparison data. Today's world it is very important to know this feature. Thanks for educating the community and appreciate your volunteership in teaching the public. Thanks a bunch

[@ExcelCampus]

Thanks again for your support Kris! :-)

[@MarissieV]

You have no idea what your video's have done for me so far. Thank you for that! It's always interesting to watch your video's and experiment more and even though it can be frustrating, especially when vba is involved and I want things that is so unique you can't find it on the internet, I get there step by step and every little step is a step forward. At the end I did it!! Thank you!!

[@ExcelCampus]

Thanks Mariska! ;-)

[@alasdairrobinson7138]

Great tip - Clear and easy to follow, thank you!

[@ExcelCampus]

You're welcome, Alasdair!

[@milinddes]

Thank you Jon for this wonderful video. Very well explained and an excellent dashboard technique

[@sandrodc69]

Very well presented and useful tutorial. Many thanks!

[@imrandaud478]

Excellent and thanks for giving free file.

[@prakashbd]

This is awesome. Thank you Jon. Great.

[@carltonseymour869]

Jon you have a gift of sharing. Thank You

[@TheSpunky19]

I agree, excellent video!

[@excelisfun]

Beautiful!!!

[@ExcelCampus]

Thanks Mike! :-)

[@waynelawrence6104]

I totally fascinated with this Doughnut Chart. Thank you, and Blessing.

[@kathysewon]

this is very helpful, however as an excel newbie, I need help with the set up before you started the video. I got through video 1 and went to this one and missed the in between set up, I am trying to figure it out. Thank you

[@DanielLamarche]

Very cool mate. Especially the apparent conditional formatting stuff. Thanks!!

[@benjaminvan2468]

The VP will like this on his Dashboard. Thank you!

[@TheZenMicro]

Thanks Jon, This helped me make a profit and loss sunburst chart that uses the ABS() function when negative to make the data work with the chart and I color it red or green when positive using your formulas, i only had to change " " to a 0 instead, i might even use your tutorial for it's intended purpose as well, great work!

[@xakirshah9748]

Thank you very much, It was super helpful for my reports...

[@spasmele]

Nice an clean, as usual. This is great for KPI reports!

[@saaneroa5024]

Awesome video. Thanks for sharing.

[@djfmate]

Excellent content Jon! This will come in handy for a possible project my boss will give me to set up a dashboard with company metrics on it! 😊

[@tinabaxter1460]

Great tutorial. Love your videos, always makes me excited to try them out.

[@malvinavartanian2203]

Great presentation.........very clear instructions. Thank you

[@rotethongvanit]

Great job!

[@PERUTICA2011]

Jon, this is a great job!!!! Thanks for sharing your knowledge with us

[@80andromeda08]

Thanks Jon for your kind efforts ❤

[@raheelmizher6189]

This is very helpful, I have a question though it sounds like there is some sort of transitioning effect on the colors when u switch from a specific % to a different one.. how can I apply this to my chart colors?

[@LM-dd9fe]

Thanks a lot Jon

[@ellisbarnes4761]

This is amazing. Sorted the doughnut and formatting and all formuals. The issue i have is with the text part - When i press equals and then click on a cell to bring in the data it comes up with ='T1 (2)'!$E$31 as opposed to the conditional example you have. Please help?

[@Julieskvz]

Very useful. I was looking for this. Thank you!

[@paulinebambalos4863]

Excellent work as usual, keep up with the informative uploads to KZbin , thanks heaps

[@fabiolorefice1895]

The 'Ingredients list' :D! Sometimes the small things just make you smile on a rainy friday morning in the office. Thak you for the informative video.

[@Zandor434]

This is great. thanks for the explanation. Do you know if this is possible w/in a pivot table & pivot chart? I am using PowerPivot to create the Remainder field. It's the charting that is the challenge.

[@apola6279]

Nice tutorial. How about if the percentage exceeds 100%?

[@souhardyachatterjee4981]

Awesome Jon

[@MohamedMostafa-dm9qy]

Thank you so much Jon , this is really valuable ❤

[@leighcook5088]

Really easy to follow instructions great stuff

[@montinaicecream1845]

How did you copy each pie chart to have the same color settings including the text box, or is it that you formatted each chart individually?

[@headzrgon2roll245]

Thanks Jon for the videos they are clean informative and very much appreciated

[@ExcelCampus]

Thanks Ian! ;-)

[@carlogo5837]

Thanks for sharing!

[@marcbrouwer7744]

Very useful and well shown on screen, thanks.

[@tamilselvi1625]

It was very helpful... thanks a lot!!!!

[@aashkuri68]

Hi Jon, Appreciate sharing this useful donuts!. I used same technique to get my first donut and duplicate 12 of them and I was very careful to change the labels and series for each one. Unfortunately, when tried later to copy and paste my percentages I started getting duplicate text boxes for no reason. Please, need some help. Thanks in advance.

[@michaelclarke5201]

Super helpful video, I'm curious to know how your chart movements look so smooth and animated?

[@richardhayden5874]

Simple but impressively useful

[@randallburrows6310]

Excellent tutorial, thanks!

[@pathofhonour2]

Thank you for sharing. Super simple and useful.

[@tish1019]

Very well explained and easy to duplicate!

[@Jewells666]

Thanks again!!

[@JohnSmith-tz7iy]

Wish you went more into detail about the numbers part like how to use equations to get the answers for the pie chart in case you want the pie chart to run by intself based of values you have input from another sheet.

[@kyfparacha]

Hi, great video. how can I do the same thing if I divide the data into four quarters? Thanks

[@ikhind]

Thank you for this excellent video. How can we show the progress over 100% ? 120% is shown like 80% ...thanks a lot in advance.

[@KentonEidse]

HI Jon, if I was doing a chart for progress towards a monthly total goal, would you be able to add a mark for the "month-to-date" point? I.e., monthly goal = 100, current actual = 60 (60% of goal), and we are at day 18 of 31 days (58% through the month). I'd like to have a mark at 58% to show that we are 2% ahead of our month-to-date goal. How would I do this?

[@christopherkurzawa503]

What if you need Level 4. Start with Red followed by Orange, Blue and Green in that order?

[@didrechsler330]

Wow Jon, that's exactly what I want to do except within a pivot chart with slicers. Thank you!

[@devnathjaiswal120]

Sir, Your Tutorial is great But we are working on Test Plan on which we have to prepare various Test-Case's, for which we face Difficulties . Sir, can you make some Tutorial for this topic. It will be great Help

[@Xeno_G23]

Keep up the good work!!!

[@manishshukla4696]

Thanks for such a nice and simple video instructions. I need to create a line chart where the target value is shown at the end and as the value changes it changes the colors (tricolor).

[@paulbarnett3349]

Hi - Great video but I have a question please - I've transferred the charts on to word document however the text in the middle transfers over but doesn't update can you help?

[@khawaja10Nov]

Great brother

[@mdjunayed380]

thanks.......... i think this types of video all-ways helpful for our kind of people............. thanks again...

[@temesgenashenafi4587]

very nice

[@muritalaadebayoisah9155]

Thank you

[@darlcandia6598]

Hi there. I followed the color formatting of the doughnut but it doesn't change color as I change the Actual value. How do you create the conditional formatting of the segments of the doughnut?

[@wasoresourcemanagementprog8876]

I have been having challenges in inserting the formula, I have followed the instruction in the video but facing difficult when inputting the formula which didnt work for me. Your formula has a this $ how can I include this sign in the formula, please advise.

[@rokiczaaa]

Thanks, I needed this tip :D

[@ExcelCampus]

Glad I could help! 😀

[@whyyounotats]

Hi there! Great tutorial! Thank you. Do you happen to know if the same is feasible with Google Sheets?

[@ZAHIDHUSSAIN-ri5kg]

Thanks John!

[@2wheelgal]

Nice presentation. I might try that for work. Cheers!

[@falehaldawsari892]

can I make doughnut chart from two data sheets? for example, i'm making pivot chart that has a slicer for 2019 and 2018 scores. the doughnut chart shows the current average score (average from the pivot chart). when 2019 and 2018 tabs are select from the slicer, the doughnut chart shows 2019 score. However, when ONLY 2018 is selected, #REF code is shown on the doughnut chart. How can I add a condition for this chart which makes the excel sheet understands that if 2019 is not selected, take another data from another table. but, if 2019 tab is selected, take the (like what is happening currently) from 2019 table. I hope it is clear :)

[@mdwasim-re8sv]

Awesome

[@hariprasad289]

Awesome, could you please share this workbooks in sites

[@starwatcher73]

do you have a Video with a horizontal bullet graph?

[@Pinkpalmpufffyslay]

Brilliant Tutorial! Thanks John. Just from curiosity, if i input "110%" in actual cell, what will happen? or how it will be shown?

[@rickandmorty529]

Heyy , Did ylou find the answer for that ? Actually , when the cell value is coming as 100% but then the doughnut graph simply disappears Would really appreciate to know if you got the answer

[@kylewindsor3363]

Good job on the donut explanation. Do you have dashboard instructions for Excel 2011 for Mac?

[@ExcelCampus]

Thank you Kyle! I do not have any tutorials for the 2011 version for Mac. I do have a series of videos on pivot tables and dashboards. Unfortunately, the Mac versions of Excel do not have pivot charts yet. Pivot charts are a great way to create interactive dashboards with pivot tables and slicers. On the Mac version you can still add slicers to your pivot tables, there is just more setup work involved in using the pivot table as the source of a chart. Therefore, I recommend using the Windows versions of Excel for dashboards when possible. I realize this is not always possible, as some companies only use Macs. Here is the link to the video series on pivot tables and dashboards. kzbin.info/www/bejne/b3-4m3t4g7yYb68 Even though you won't be able to use all the techniques taught in those videos, it will still provide training on pivot tables. Pivot tables are the best way to quickly summarize your data for dashboards. On the Mac versions, you can still use the pivot tables as the source data for your charts. You will just need to create dynamic named ranges to use for the source ranges of the charts, since you can't create linked pivot charts. I don't have any tutorials on that yet, but will add it to the list. Thanks again and have a nice weekend! :-)

[@thomasw.857]

Thank you very much!

[@mohamedchakroun4973]

Thank you jhon

[@valennpalamine3016]

Can someone help me why my data series input is in decimal form not in percentage form?

[@davidblackadar5883]

This is great. I am sure I will impress my colleagues. However, I am not getting the % symbol in my text box. The cell value is a percent. What am I doing wrong?

[@davidblackadar5883]

got it

[@jaskhoo1]

not sure if i did something wrong but chart is not keeping color formatting :(

[@irmaleticiaalvarezrabago3222]

Great thanks

[@sucmitra]

I can do the formating on same chart, but 3 different chart with all same linking, i wasnt able to do it.. :(

[@ihtashamzafar6713]

very nice kindly share the school management system dash board video who to mak it

[@BkBandit67]

Jon, I’m still getting the decimal in my chart. How do I get it to go back to the way you have it on this tutorial?

[@stevecraddock646]

Use the formatting under the %age drop down box

[@numairfadlullah1652]

awesome!

[@lookme4212]

EASY CLEAR MANNER

[@inarkamal]

the color of my progress (i.e. completed section) stays the same even though I change percentages. I followed your instructions. What do you think I'm doing wrong? Are there common errors?

[@marwynn2]

I have the same issue

[@ExcelCampus]

Hi Inarkamal, You can download the file with the example at the following link. www.excelcampus.com/charts/progress-doughnut-chart/ You might want to compare that file with the one you created. It's hard for me to tell what might be missing.

[@rezakheyrandish779]

Excellent :)

[@mohammadafsari4686]

Tnx for nice video just i couldn't understand time of 4:10 video when you dragged c5 till c8

[@mohammadafsari4686]

And when I dragged icon down all cells turn to 55%

[@krishnaRaog21]

Wonderful

[@peterl2866]

Cool

[@lambeaubairn]

Perfect, helped me out :)

[@saviodcunha2830]

thanks awesome

[@jawadrasheed7460]

Instead of using multiple text boxes, we can do this with one text box. But have to go with one color text

[@ExcelCampus]

Hi Jawad, that is correct. You could use one textbox if you don't want the color to match the bar.

[@KamranMumtazAhmed]

@@ExcelCampus It seems he didn't get your concept... ;-)

[@dilshadahmad4269]

Nice

[@hansikaprakash8007]

if the cells colours is red , we need text as no. and the cell is green , the text shold be yes. how to do it

[@ExcelCampus]

Hi Prakash, you can use an IF formula for that. Here is an article on the IF function. www.excelcampus.com/functions/how-to-write-if-function/

[@alexrosen8762]

Wow!