With your video populated on one monitor, i was working in another monitor to create what my Boss requested me to do and i've done it with success and pride, all because of you. Thank You again, my friend.
i was hesitant to watch another excel dashboard like youtube video but honestly you really did a tremendous job explaining and showing what you did thank you so much!
Greetings from Indonesia. Really enjoy learning from Your tutorial. The step by step process are well explained and makes it easy to follow. Thank You!
very clear and concise information and very easy to understand, I feel this is something I could do now, so many tutorials seem to be too quick, but I picked this up a lot more easily with the clear, relaxed voice and explanations - thank you.
Thank You very much Nabil, You are awesome. I had been trying to learn the Pivot Tables and Slicers and no was able to teach me cos I am such a thick skull. :) but you 26.28 minutes or video was extremely engaging and clearly defining each and everything that I now understand how to work with Pivot Tables and design the reports my boss has been asking for :) Thanks Very Much, Only Allah can reward you for such a great teaching,
This tutorial is amazingly good. I learned a lot from it and it gave me some inspiration for my classes (I give Excel classes to students). Thank you so much! Fan +1 😊
using equal in cell text box will only work if =GetPivot function is off. If you don't want to off it then you'll need to create a helper-identical column of Sales Revenue
First of all I would like to than you for awesome presentation. In this tutorial I'm unable change series chart type since custom combination is not available to select secondary axis. Note:- I am doing this on Excel 2007
Very nice and helpful for a beginner like us. No idea who all dislike this tutor.. anyway m very much happy and definitely try with my project with this formula 👍👍👍
I thoroughly enjoyed your tutorial! Thanks so much. I did want to inquire though if you could explain the intent of how the helper column impacts the progress doughnut chart? Why exactly was that necessary (the '=1' equates to 100% is what I figured) but how does that actually interplay into the chart in the interactivity part?
minute 11:30 , it shows a secondary axis which 39% is the actual sale ( the actual part that will be seen) and 61% the transparent which is the leftover, non sale
Cool. I've just used this in one of my dashboards. One problem I've run into is that for certain filter combinations some of the rows have no output (the value is zero) so Excel hides it which means that the doughnuts pick up the wrong row. I had to use the field settings to make sure it shopws row with no data. By the eay, what version of Excel are you usign there? At work I have to use Excel 2010 because of compatibility with vertical applications, that doesn't let you do the secondary axis. On my personal machine I have Office 365 Pro Plus (Semi-Annual channel) which does but I noticed that some of the settign look different. If I create the dashboar don my personal machien it still works in 2010 on my work machine. Thanks.
In this case you have to make sure that all Seller ( for example) have done some sales on all regions so you can insert a data for all seller for all regions with 0 amount. So even if the seller did not sell for an specific region it would appear as 0. That is how I resolved here.
Thank you for the nice comment. Kindly share my tutorials to your social media... You can download the start file by going to my website www,OfficeInstructor.ca and click on "Downloads"
Thank you so much for sharing your knowledge about this topic. I love to improve my excel skills, specially pivots and charts and this video it's great!
![Doughnut Chart for Excel Dashboards: Simple and Easy way! [Excel Free Template]](http://i.ytimg.com/vi/PcnLu4yzH_Q/mqdefault.jpg)
With your video populated on one monitor, i was working in another monitor to create what my Boss requested me to do and i've done it with success and pride, all because of you. Thank You again, my friend.
Excellent Tutorial and thanks a lot !
You are Welcome
i was hesitant to watch another excel dashboard like youtube video but honestly you really did a tremendous job explaining and showing what you did thank you so much!
Glad it was helpful!
literally THE BEST!!! Thank you so much!
Thank you
@@Officeinstructor i am unable to add my value in text box after selecting = sign
That was a brilliant walkthrough in creating a pivot table with dynamic doughnut chats.
I am happy you liked it
The best Ms Excel tutorial I've come across 💯. Thanks
Thanks for watching
Just a fantastic tutorial. One of the first I found easy to follow and paced to be instructive.
Thank You
I don’t normally comment on videos but this tutorial was absolutely fantastic. You have saved me a lot of time and headaches.
Thank you for the encouraging comment... Please share on your social networks
Wow! I never realized how polished Excel can be! Thank you for the tutorial. It's very helpful.
You're welcome. Please subscribe to be notified about new tutorials.
Greetings from Indonesia. Really enjoy learning from Your tutorial. The step by step process are well explained and makes it easy to follow. Thank You!
What a perfect lecture and lecturer. Thank you for being so patient and crystal clear
Thank You Valentine
Thank you
Voice is soothing and you speak at a pace to understand/follow.
absolutely terrific thank you. Particularly impressed by repeating the steps verbally makes it much easier to take notes of tricky keying.
You're very welcome!
Great Teacher. Very clear step by step guidance
Many thanks!
very clear and concise information and very easy to understand, I feel this is something I could do now, so many tutorials seem to be too quick, but I picked this up a lot more easily with the clear, relaxed voice and explanations - thank you.
You're very welcome!
I invite you to watch the hundreds of other tutorials I have ... and Subscribe to my channel
pure gold of 26 minutes, can't believe its free. thank you, sir, for the wonderful video.
Did you watch my recent tutorials?
I guess you'll like them too
Thanks for a wonderful free tutorial lesson.
What a GREAT instructor, and great content!!!!!!!!
Thank you Pame... I encourage you to watch my other tutorials and Subscribe to the channel
Such a great video, I would pay to learn this yet you offered it free, I salute you.
My audience across the world deserves the BEST
thanks a lot M.Treacy I am personally motivated with your lessons.
You are very welcome Ngum.
Mynda Treacy is one o f the best instructors in the world. But, I am Nabil Mourad.
thanks for explaining everything step by step and easy to follow. I'm not native english but your pronunciation is clear and brief for me
Nobody would have explained it better than u did.Thank u so much.
Thank you my friend
Thanks a million...... I rocked in my presentation with your guidance........Thank you so much! God bless you!
Thank you for the nice comment... Did you Subscribe to my Channel? The Best Is Yet To Come
Thank you so much. Very simple and clear explanation running through the video and same time action taking place on laptop
This is perfect! i am sure anyone can implement this after going through this tutorial for just once! Thanks for explaining it so well.
Brilliant. I followed and it was like a walk in the park.
This tutorial is truly amazing and brilliant. Thank you for all the steps explained. Very precise!!
Thank you for very easy and clear speaker, and mixed it with fantastic ideas.
Thank you
what a great job, Congrats! Thanks for sharing your knowledge!
Thank You very much Nabil, You are awesome. I had been trying to learn the Pivot Tables and Slicers and no was able to teach me cos I am such a thick skull. :) but you 26.28 minutes or video was extremely engaging and clearly defining each and everything that I now understand how to work with Pivot Tables and design the reports my boss has been asking for :)
Thanks Very Much, Only Allah can reward you for such a great teaching,
Thank you Kashif for the nice words. It is a pleasure to be able to help you in learning a topic in Excel
This tutorial is amazingly good. I learned a lot from it and it gave me some inspiration for my classes (I give Excel classes to students). Thank you so much! Fan +1 😊
You are most welcome
Awesome sharing. This is what exactly I look for - clear steps and explanation. Well Done. Thanks for sharing.
You are welcome!
Well done! Just the one step of using the equals and cell for the text box was new to me (along with much more) and worth watching.
Me too.
Nice one.
using equal in cell text box will only work if =GetPivot function is off. If you don't want to off it then you'll need to create a helper-identical column of Sales Revenue
Best tutor so far. Great. Thanks...
Wow, thanks!
well explained. thank you so much sir,
Ciao e piacere di Aver conosciuto i vostri video.
Very detailed intructions. Thanks, i learned a lot!
Glad it was helpful!
Well done Sir...Thank you for sticking to the point and explain things very clearly... Just well done...
Thank you and glad you like it... I invite you to watch my latest tutorials
Very nicely explained and each step is shown very properly so it easy to understand .. liked it
Amazing Tutorial. thank you so much!
Brilliant Easy to Follow, Step by Step Instructions! Kudos to the Tutor 👏🏼👏🏼
Thank You Vishal
Thank you for sharing such a piece of good knowledge!!
Thanks for sharing wonderful knowledge Pivot Table in Excel.
Hi there, this was a fantastic video! Thank you for this!!
Thank you
Glad you like it... Watch and share my newly posted tutorials
Good job sir! Straight to the point explanation. Thank you!👍
Top tutorial! Thank you very much for sharing.
Sophisticated explanation Sir.
Great video thank you. Could we modify the data to implement conditional formatting, i.e change in Green if for example above 80%, but red otherwise?
Great tutorial for me. Thank you very much. We wait for the next!
First of all I would like to than you for awesome presentation. In this tutorial I'm unable change series chart type since custom combination is not available to select secondary axis. Note:- I am doing this on Excel 2007
Please download Office 2016 from official website of Microsoft. I will provide you activation key
Yes u can, you need to apply the whole process on primary axis.
Boss you are genius !!!! You made my report so attractive and easy
Very smart and professional
Thank you
Thank you for your nice comment.
Please share the video on your social media
Thank you so much for the video. Was very helpful. Look forward to more content on data analysis.
More to come!
Phenomenal tutorial
Very Good tutorial. Many important tricks I understood from this tutorial. thank you.
Thank you... Glad you liked it
Very nice tutorial. Thanks a lot!
This is so solid and can be applied to all kinds of data. Thanks so much.
Glad you liked it
super, thanks for teaching, left my tip :)
Very nice and helpful for a beginner like us. No idea who all dislike this tutor.. anyway m very much happy and definitely try with my project with this formula 👍👍👍
I thoroughly enjoyed your tutorial! Thanks so much. I did want to inquire though if you could explain the intent of how the helper column impacts the progress doughnut chart? Why exactly was that necessary (the '=1' equates to 100% is what I figured) but how does that actually interplay into the chart in the interactivity part?
minute 11:30 , it shows a secondary axis which 39% is the actual sale ( the actual part that will be seen) and 61% the transparent which is the leftover, non sale
Very nicely explained..... Thanks for the tutorial
Wonderful tutorial
Thank you for your nice comment.
Please share the video on your social media
thank you, it is really good to see your dashboard, the way you explained is pretty good
Glad you liked it
Thank you so much!!! Love it 💖
presentation & trainning is superrrrrrrr
Thank you so much 🙂
it's look so nice , appreciated.
Jessica and Mike are lucky to have such a great tutor!
Cool.
I've just used this in one of my dashboards. One problem I've run into is that for certain filter combinations some of the rows have no output (the value is zero) so Excel hides it which means that the doughnuts pick up the wrong row. I had to use the field settings to make sure it shopws row with no data.
By the eay, what version of Excel are you usign there? At work I have to use Excel 2010 because of compatibility with vertical applications, that doesn't let you do the secondary axis. On my personal machine I have Office 365 Pro Plus (Semi-Annual channel) which does but I noticed that some of the settign look different. If I create the dashboar don my personal machien it still works in 2010 on my work machine. Thanks.
In this case you have to make sure that all Seller ( for example) have done some sales on all regions so you can insert a data for all seller for all regions with 0 amount. So even if the seller did not sell for an specific region it would appear as 0. That is how I resolved here.
I used at the time of recording Office 2016...
BTW, forward compatibility always works, backward compatibility not guaranteed.
What exactly did you do to solve this problem. I'm facing same problem.
just super! So many tricks are illustrated in this one project so well and with such ease. nice!
Thank You
Great video Nabil. Thanks for sharing. Think i'll have doughnuts for dessert later too. :-)
This is a very powerful instructional video. It's clear and easy to understand. Thank you Nabi ! ! !
When i click on donut arrow it forces me to chose between the existing ready donut
Superb video, great illustration and you covered it so well in this video
Thank you so much 😀
GENIIIIIIIIIOUSSSS!
you are so kindness
No
Thank you very much for this amazing tutorial.
جزاك الله
Would you please add source file for downloading.
The best tutorial for Pivot Table, Progress chart and Dashboard all in one place
Thank you for the nice comment. Kindly share my tutorials to your social media... You can download the start file by going to my website www,OfficeInstructor.ca and click on "Downloads"
@@Officeinstructor what is the file's name?
File name: "Progress Doughnut Chart"
I do not understand how do you got some dislikes, its simply cool and easily understandable.. Appreciated..
@@mukundanandan8614 Because the file on link has only source, no doughnut chart, may be, the reason!:-)
Interesting and smart way to create the donut charts.
Very great Nabil so nice presentation and explanation very vivid
Glad you liked it... Watch my recent tutorials
Superb Sir. I dont understand the thumbs down business. Post more videos.
Thank you Anand...
For the Thumbs down, it simply shows that in Life you cannot make everyone happy... Even god did not make everyone happy
Sir! You are really one of the great teachers .
Thanks for the Tutorial. It looked difficult in the beginning, but you made it easy to learn. Learnt something new today.
Brilliant and simply superb...I have never seen such video on office yet..I am amazed how you did all this in an Excel....Great Job keep it up.
Glad you liked it... Did you subscribe???
Stay Tuned... The Best Is Yet To Come
Thank you so much for sharing your knowledge about this topic. I love to improve my excel skills, specially pivots and charts and this video it's great!
Glad it was helpful!
I LIKE THE WAY YOU SPEAK THANK YOU SO MUCH
Thank You
Very clear explanation, and everything step by step...brilliant...congratulations!! Awesome job!
Thank you very much!
Amazing video! Easy to follow and execute. Thank you!
You're very welcome!
Awesome explanation. I am very greatful to you. Thank you.
Brilliant ...amazed what excel can do - i never knew
Keep learning
wow! what an impressive dash board! thanks for sharing your expertise
Thanks for watching!
Clear and concise!
Glad you like it
Very well presented. Perfect pace and step by step explanation. Subscribed!
Thank you Alfonso
Ok
Fantastic Job. Well presented.
very interesting, very good material 😘
Fantastic Report and explanation. Hats off. I have a query, if the value is 0 for any row, what are the steps to be followed. Please explain.
Will be posting a video on that
This is very great sir
Thank you so much, I followed it and I got it
Wonderful tutorial and very useful................ Thank you !
Staggering. Amazing. Thank you very much. If you come to Ireland, I'll buy you a beer!!!
Ok deal
and if you come to Toronto, I'll get you a beer as well
Definitely awesome! thank you for sharing
Thanks for watching!
this was an awesome presentation. very patient, well articulated, and you know your stuff. the short cuts were amazing too.
You are most welcome
I enjoy it and your video help a lot THANK YOU SO MUCH!
Glad it was helpful!