Hi all... Hope you found the video useful. Like this comment if you want to see an "ADVANCED" version of this gantt chart with progress indicator, switch between daily / weekly and option to exclude weekends.
Lovely Video clip! Sorry for the intrusion, I am interested in your initial thoughts. Have you ever tried - Weydaniel Organized Dominator (do a search on google)? It is a good exclusive guide for getting 7000 plus project management and business templates minus the hard work. Ive heard some amazing things about it and my m8 after a lifetime of fighting got amazing results with it.
I must have been living under a stone that I didn't notice your youtube channel before. Your tools and tips on the internet have helped me so many times over the last 2 decades. You are brilliant!
This is fantastic, thanks! Features that I'd like to see: 1. Exclude weekends and holidays 2. Effort estimation 3. Fill the activity Gantt chart with planned vs actual progress 4. Move completed activities to history and always view activities in progress and upcoming activities first 5. Select the Week for which you want to view the data ( to view past activities)
You are welcome Gaurav... You can easily customize the file to add these things. 1. Use workday() instead of +1 2. Effort = duration x hours per day 3. This is something I plan to cover in an advanced video 4. You can use Power Query to remove old & completed activities when they reach pivot table. 5. Add a form control and link it to either start.date or change the formula logic. All the best.
Wonderful. Years ago I used Excel for Projects because it gave me more flexibility that MS Project and was more accessible for others. This is a more robust PM than the ones I created long ago. Thank you!
The Lego mini-figures absolutely made my day! I just found your channel while looking for info about Power BI and I'm already excited to watch more! Keep up that wonderful sense of humor 😁😁
Thank you so much. This tutorial made Gantt chart making a piece of cake. Amazed by the procedure, I visited your website which turned out to be a gold mine. Kudos🤩🤩
Anna.. Baahu and Bhalla made me chuckle .. too much creativity boss!! You can even create an analysis to find why did katappa kill baahubali!! Lol.. Jokes apart. I love the way you deliver your lectures. More power to you, keep going!!
Thank you that in the current lock down I happen to visit one of your videos and could connect with you in this life of mine ..... I do work a Lot in excel and I am aware of many short cuts and tricks but you are really amazing ! Thanks for enriching the life of poor souls ! My compliments and prayers for you ! Thanks a ton ! I must have watched many videos of yours by this time and look forward for all new uploads.
Great share ! thx much ! How would you insert a ◄ at the start and ► at the end of the gannt bar. I can do it comparing the activity start date to the date on top of that col ; ie activity start date = the col date then col = ◄, and similarly for the end of the bar. But since the bar is made of format control it doesnt fit in. The entire bar also has to be made up of shapes like ▇ ; any thoughts ?
Hey i love watching your videos and i learned a lot but i have a question. i started trying to leave more about because of my work where i have to crunch data (i'm not good at it) that has been exported from Service Now and i try to use your examples to do this but sometimes i get lost. Can you make a video based on Service Now?
Hi there Chandoo🌈🌞, I really learned a lot from you videos, and is currently following your Project Management Dashboard Excel Demo. I tried applying IF Formulae to get rid of those Blank Date after the slicer applied, it was not working. I wonder if you could teach me how to do that (About those 0 value in your video shown at 10:40 clips). Thank you very much!🌈🌞
Chandoo great tips. Thanks for sharing your knowledge. I am looking for a way to stay organized in my day today things to do lists. Any tips on where and how to manage “ things to do” tasks while on a job. I use pen and paper becoz I can be flexible the way I want yo use it. Being an IT consultant I sometimes draw a process a flow diagram to capture my thoughts in things to do list and so on. Any suggestions is welcome. Thanks Chandoo.
Thanks Ari... I use notebooks and have built a collection of them over years as I am _kinda_ old school. But for more intense projects, I use One Note and add events to my calendar. These days, for my UA-cam videos, I have been making a list of *things to do* on my paper notebook and check them off as I progress. Hope that helps.
You are welcome. Instead of =previous date + 1, try this pattern first cell after start.date = previous date + 0.25 next cell = previous date + 0.75 now repeat this.
Hi Chandoo, I'm awesome at excel because of your channel. Why at 7:57 you used Xlookup to fetch the data instead of including them in the initial Pivot table? Thanks
Thanks Abdulaziz. You can do either. I used XLOOKUP as we may want o fetch few more details from the data and adding everything to Pivots can be a pain.
@@chandoo_ it seems as you said that adding everything to a pivot is a paint ..I’ve added all of the Gantt Chart headings into the “rows” field of the pivot . For some reason the slicer is not working !
Hello all... The full series is out now. Watch the next videos here - Part 2 - Project progress charts - ua-cam.com/video/C0F_VKlTX1c/v-deo.html Part 3 - Preparing the final dashboard - ua-cam.com/video/Exlj5qH0rhc/v-deo.html
im using microsoft excel 2013 and at 3:26 you mention to summarize as min however received the following error "pivot table we can't summarize this field with min because its not supported calculation for date data type" unable to see possible solutions in the net so far
You can use a measure instead. Right click on the table name in pivot table fields list and create a measure with below formula. =min(plan[startdate]) Hope that helps.
@@chandoo_ thank you chandoo. initially my data does consist of text but error message still sustain even after i have made adjustments (and clicked data refresh) . for some reasons, it went ok 👌 after i redo the pivot table.
Awesome Dashboard! Chandoo... My Conditional Formatted Day bar is not working correctly. If I have today set as: =Today() it displays but if I subtract a day it disappears. In format rule I have =J$3=TODAY(). I'm using Excel 365 on Current Windows, any idea what is wrong?
Thanks Mike... There could be two reasons. 1) the conditional formatting rule is incorrect. If you want to check & highlight yesterday, you need to put brackets, like this =J$3=(TODAY()-1) 2) You are checking for a day that is not in the top row. This can happen if you filled only weekdays and checking for a weekend date. Hope that helps.
@@chandoo_ Well it's giving me something to go on. I'll do the exercise over from the beginning, I must have missed something. Ha, I could use the practice anyway! Thank you. & thanks for the quick response.
With Excel 365, you can place the file on onedrive or teams folders and others can update it. As the focus here is on one project, it would be tricky to add multiple in this format. See my other article for a project portfolio dashboard - chandoo.org/wp/design-project-portfolio-dashboard/
Hi Chandoo! this video is gold! I have 2 questions: 1.- is there a way to get the into the Gantt "in progress" tasks and 2.- how can we red flag delayed tasks?
Hi, can you also include planned start and end dates along with Actual start and end dates. Also if the Gantt chart can show the highlights of the dates or the lag that is caused.
Hi Chandoo, can you add 2 things in the gantt chart as per project requriement. 1. Plan dates & Actual dates 2. Critical pathes of the process. Please advice
Thanks Nischal for the comments. Adding Plan vs. Actual view is straight forward. You can do it as a challenge. Adding Critical path is tricky with Excel formulas alone. I suggest not using Excel for performing CPM / PERT analysis.
This is an awesome tutorial. Although, when the start and end dates on the 'people and data' page are empty (before starting a project for me), the pivot table removes the min/max columns. Is there any way I can keep these here even when the date fields are empty on the other table. Thanks!
Don't think so, but few others have asked about Google Sheets compatible dashboard. I will give it a try and make a video. Its going to be a while so be patient.
👉 *Read this If you have trouble with MIN & MAX dates* in Pivot tables: This seems to a problem with Excel 2016. You can use Power Pivot measures to get the same result. Right click on the table name in pivot table field list and select "add measure" option. Then name the measure as "start of activity" or something and use the =firstdate(activity[start date]) Do the same for max, but use the DAX formula =LASTDATE()
You can hide that row or make it disappear with ;;; trick. Once you add the activities, just hit REFRESH in data ribbon and they will flow to the dashboard.
question, what's the difference between infographic vs dashboard ? may be a dumb question but i been asking to create infographic in excel, i double check in youtube and it's the same as a dashboard, am i missing something ?
They are similar. In my book, infographic is something that is not usually interactive. So perfect for printing, presentations or emails. They are also designed like posters - ie engaging, often funky and tell a story. Dashboards on the other hand are usually one page data stories that tend to be interactive and rich with data & insights. You can use either word for what I have shown in this video and it doesn't make a difference. Hope that helps.
Chandoo, Thank you for this video! is it possible to have 3 different teams (in my case architects, engineers and construction teams) then create projects or jobs for those teams as well as a actual team members for each job?
Hi Alex.. you can tweak this file to make such project plans. Alternatively, you can create a base version with all team & people data and then split to three files (and may be use Power Query to bring relevant data to each file) and use that to make the dashboards.
Chandoo, great video. Question regarding the section where you're changing the Count of Start to date(Min) Count of Finish(Max). I can't seem to apply that as on mine they are grayed out, please advise
Thanks Juan... This seems to a problem with Excel 2016. You can use Power Pivot measures to get the same result. Right click on the table name in pivot table field list and select "add measure" option. Then name the measure as "start of activity" or something and use the =firstdate(activity[start date]) Do the same for max, but use the DAX formula =LASTDATE()
Hi Chandu, I want to make a project management tool where I can track development progress as like start date end date and followed by test plan start date and end date and finally test execution start date and end date by the resources and the team lead and would be great to filter by task IDs (development JIRA ID) by the client or multiple clients or all clients... Pls help
On top of this I need to create resources allocation where 1 tasks can be assigned to more than 5 or 6 persons for testing or development etc. Pls help
Hi Chandoo, I really appreciate the effort you put in, i downloaded your blank file and when i summarize by MIN it does not allow me to do it because startdate and enddate is not date data type, i tried to reformat the data to date type in activity table, but it does not work, hope you can help with this, Thank you !
Hi Minh... You are welcome :) This seems to a problem with Excel 2016. You can use Power Pivot measures to get the same result. Right click on the table name in pivot table field list and select "add measure" option. Then name the measure as "start of activity" or something and use the =firstdate(activity[start date]) Do the same for max, but use the DAX formula =LASTDATE()
If you are talking about animated race graphs that you see online, those are tricky to make in Excel and frankly not worth the effort. If you mean something else, let me know what you have in mind.
Hie Sir, do you have any real time example that how project scope and project planning for any project actually look like??? If you have , it will help me for my further studies and preparations
Sure.. For a start, you can do this easily by adding conditional formatting rule to highlight weekends in dull color (just as we did for TODAY) For overdue items, you can modify the ✅ rule and add a condition to show red flag when %done is
Hi Sanjeev... please refer to the article here for a detailed tutorial of the dashboard. It has extra links on the individual bits too. chandoo.org/wp/interactive-project-dashboard-with-excel/ Happy learning.
I am using the downloaded file, After creating the pivot table I am not able to summarize the dates by min and max. The min and max options are shown greyed out. Using excel 2016 desktop
This seems to a problem with Excel 2016. You can use Power Pivot measures to get the same result. Right click on the table name in pivot table field list and select "add measure" option. Then name the measure as "start of activity" or something and use the =firstdate(activity[start date]) Do the same for max, but use the DAX formula =LASTDATE()
hello chandoo thanks for the videos and your website is filled with great lessons currently I''m working on excel form for daily production. which is for my manufacturing plant. and i learnt lot from you ... thank you once again . PEACE
This is amazing Chandoo!!! I just have a question. I have my Gantt Chart arranged in mmm-yy format, instead of your format. How do I highlight the current month column?
@@chandoo_ Thanks so much Chandoo!! It worked :) but I didn't start my formula like how you showed in the video with =(date cell)= .... it wasnt working when i did that... it worked only when i started the formula with =AND(........) .... I hope that wont cause any issues...
Hi all... Hope you found the video useful.
Like this comment if you want to see an "ADVANCED" version of this gantt chart with progress indicator, switch between daily / weekly and option to exclude weekends.
LOL... 'This' is the simple version?? (great vid, just very complex to the junior user).
Great vid, Could be possible to add actual progress to that Gant chart?
Lovely Video clip! Sorry for the intrusion, I am interested in your initial thoughts. Have you ever tried - Weydaniel Organized Dominator (do a search on google)? It is a good exclusive guide for getting 7000 plus project management and business templates minus the hard work. Ive heard some amazing things about it and my m8 after a lifetime of fighting got amazing results with it.
I must have been living under a stone that I didn't notice your youtube channel before. Your tools and tips on the internet have helped me so many times over the last 2 decades. You are brilliant!
Thank you Mo. So good to have you here too.
You've been my go to right form 2011 but I used your website alone not your videos.
This is fantastic, thanks!
Features that I'd like to see:
1. Exclude weekends and holidays
2. Effort estimation
3. Fill the activity Gantt chart with planned vs actual progress
4. Move completed activities to history and always view activities in progress and upcoming activities first
5. Select the Week for which you want to view the data ( to view past activities)
You are welcome Gaurav...
You can easily customize the file to add these things.
1. Use workday() instead of +1
2. Effort = duration x hours per day
3. This is something I plan to cover in an advanced video
4. You can use Power Query to remove old & completed activities when they reach pivot table.
5. Add a form control and link it to either start.date or change the formula logic.
All the best.
Every time I get stuck, I know you will have great resources to help. You rock!
Wonderful. Years ago I used Excel for Projects because it gave me more flexibility that MS Project and was more accessible for others. This is a more robust PM than the ones I created long ago. Thank you!
Thank you Elizabeth... Excel offers flexibility and creativity that other tools lack.
You're an "excel"lent teacher. Thanks a ton, Chandoo!
You are amazing
Thanks for the love and super Matoell 😍
I'm loving your videos, you keep me entertained long enough to learn things!
The Lego mini-figures absolutely made my day! I just found your channel while looking for info about Power BI and I'm already excited to watch more! Keep up that wonderful sense of humor 😁😁
Thanks DB. I love 😍 LEGO and it was adding a bit of that to this video series. Welcome to my channel btw...
Hey @Chandoo. I just came for first time on your channel. I subscribed.
This is gold !
Thanks !
Welcome aboard!
Awesome Chandoo! Lots of great tips and tricks in this video. Thanks for sharing :)) Thumbs up!!
My pleasure 😊
Chandoo, trust me you are everybody’s friendly bandhu 🙃
Thanks for making life a lil easy through your informative content.
Awesome video as always Chandoo, this will help be massively. Thanks.
Hi Chandoo , thanks bro , I came here when I saw your smile on the thumbnail ) ...
So nice of you
Excellent tutorial and thanks for the freebies!!!
Liked the episode. Humor is good.. Concept and teaching is amazing.
Thanks Priti. :)
Thank you so much, Chandoo! This is very useful for me. Downloaded your templates on your website! Thank you so so much!
You are welcome Rainymay...
Chandoo the man! Our very own Wiz ✌️
Thank you ...
Thank you so much. This tutorial made Gantt chart making a piece of cake. Amazed by the procedure, I visited your website which turned out to be a gold mine. Kudos🤩🤩
Thank you Chandrani. Welcome to my channel and site. 😀
Anna.. Baahu and Bhalla made me chuckle .. too much creativity boss!! You can even create an analysis to find why did katappa kill baahubali!! Lol..
Jokes apart.
I love the way you deliver your lectures. More power to you, keep going!!
Thank you that in the current lock down I happen to visit one of your videos and could connect with you in this life of mine ..... I do work a Lot in excel and I am aware of many short cuts and tricks but you are really amazing ! Thanks for enriching the life of poor souls ! My compliments and prayers for you ! Thanks a ton ! I must have watched many videos of yours by this time and look forward for all new uploads.
Thank you Dharmendra for your love and appreciation. Stay safe.
What a trick sir, never thought about using color filter like that.
Glad you liked it
Hi sir I am using Excel 2013 and I am not able to Right click on the table name in pivot table field list , so what should i do now ??
Do your templates provide monitoring for key stages and dependencies?
This is awesome work, Chandoo. Now I am thinking on how to use PTs from another sheet to do calculations at the next level
Thank you.. Go for it!
This is great. Will definitely use this in future.
Thanks Purna!!!!!!!
Thank you Pektus...
Great share ! thx much ! How would you insert a ◄ at the start and ► at the end of the gannt bar. I can do it comparing the activity start date to the date on top of that col ; ie activity start date = the col date then col = ◄, and similarly for the end of the bar. But since the bar is made of format control it doesnt fit in. The entire bar also has to be made up of shapes like ▇ ; any thoughts ?
Hey i love watching your videos and i learned a lot but i have a question. i started trying to leave more about because of my work where i have to crunch data (i'm not good at it) that has been exported from Service Now and i try to use your examples to do this but sometimes i get lost. Can you make a video based on Service Now?
Awesome. Can't wait for part 2.
Thanks Vincent... won't be long.
Hi there Chandoo🌈🌞, I really learned a lot from you videos, and is currently following your Project Management Dashboard Excel Demo. I tried applying IF Formulae to get rid of those Blank Date after the slicer applied, it was not working. I wonder if you could teach me how to do that (About those 0 value in your video shown at 10:40 clips). Thank you very much!🌈🌞
love this.. very clear explanation
Glad you think so!
Thank you and a bear hug, Poorna.
Hugs to you....
Your pronunciation of 'Gantt' and referencing it to Wendy... got me rolling on floor.... overall I enjoyed the tutorial...
Chandoo great tips. Thanks for sharing your knowledge. I am looking for a way to stay organized in my day today things to do lists. Any tips on where and how to manage “ things to do” tasks while on a job. I use pen and paper becoz I can be flexible the way I want yo use it. Being an IT consultant I sometimes draw a process a flow diagram to capture my thoughts in things to do list and so on. Any suggestions is welcome. Thanks Chandoo.
Thanks Ari... I use notebooks and have built a collection of them over years as I am _kinda_ old school. But for more intense projects, I use One Note and add events to my calendar. These days, for my UA-cam videos, I have been making a list of *things to do* on my paper notebook and check them off as I progress. Hope that helps.
This is awesome my friend !! Liked, commented :) and subscribed!! Cheers
Thanks Chandra and welcome to Chandoo community.
This is awesome! How would I break up the dates into AM and PM sections?
You are welcome.
Instead of =previous date + 1, try this pattern
first cell after start.date = previous date + 0.25
next cell = previous date + 0.75
now repeat this.
@@chandoo_ Thanks!!
Wholesome and informative
Hi Chandoo, I'm awesome at excel because of your channel. Why at 7:57 you used Xlookup to fetch the data instead of including them in the initial Pivot table? Thanks
Thanks Abdulaziz. You can do either. I used XLOOKUP as we may want o fetch few more details from the data and adding everything to Pivots can be a pain.
@@chandoo_ it seems as you said that adding everything to a pivot is a paint ..I’ve added all of the Gantt Chart headings into the “rows” field of the pivot . For some reason the slicer is not working !
Excellant explanation. Thanks a lot sir.
Super, Chandoo
Thank you Venkat.
A great video Chandoo. Thinking of marketing campaign tracking I would add a days remaining column, highlight weekend and public holidays.
Hello all... The full series is out now. Watch the next videos here -
Part 2 - Project progress charts - ua-cam.com/video/C0F_VKlTX1c/v-deo.html
Part 3 - Preparing the final dashboard - ua-cam.com/video/Exlj5qH0rhc/v-deo.html
Awesome video, great work. You make it look so easy 😃
Excellent one quick and superb fast. Thank you Chandru ❤️
Thanks Kannan
What is the benefit in relationship, I do not see that we have used here, am I right? please advice
Bhai, You are awesome!
Thank you Salahuddin... 😊
This is so good to learn, straight subs to your channel. Thanks a lot for that simple explaination.
Thanks brother...:)
im using microsoft excel 2013 and at 3:26 you mention to summarize as min however received the following error "pivot table we can't summarize this field with min because its not supported calculation for date data type"
unable to see possible solutions in the net so far
You can use a measure instead. Right click on the table name in pivot table fields list and create a measure with below formula.
=min(plan[startdate])
Hope that helps.
@@chandoo_ thank you chandoo. initially my data does consist of text but error message still sustain even after i have made adjustments (and clicked data refresh) . for some reasons, it went ok 👌 after i redo the pivot table.
WOOOOW!! Brilliant!! Thank you
You are welcome Laura...
Sir this is simply insane. I'll surely use it to track my own work performance 😀😍😍 blessed that I came to know about you❤❤❤❤
Thanks Raghavendra.
Chandoo bhai ko mein 10 years sey track kar raha hoon. From his website
Yes mate, a Chandoo a legend
@@arindamdutta9371 Thanks Arindam for all your love and support :)
Thanks.. pls make video on inventory management dashboard
i like this video, you can add the display week by using scroll bar option , it will easy to display by weekly progress.
Thanks Ramasubbu... Yes, this can be easily enhanced with many other features.
Awesome Dashboard! Chandoo... My Conditional Formatted Day bar is not working correctly. If I have today set as: =Today() it displays but if I subtract a day it disappears. In format rule I have =J$3=TODAY(). I'm using Excel 365 on Current Windows, any idea what is wrong?
Thanks Mike...
There could be two reasons.
1) the conditional formatting rule is incorrect. If you want to check & highlight yesterday, you need to put brackets, like this =J$3=(TODAY()-1)
2) You are checking for a day that is not in the top row. This can happen if you filled only weekdays and checking for a weekend date.
Hope that helps.
@@chandoo_ Well it's giving me something to go on. I'll do the exercise over from the beginning, I must have missed something. Ha, I could use the practice anyway! Thank you. & thanks for the quick response.
Fabulous! Thank you!
Thank you much Chandoo , great video as always. Looking forward for your 2nd part of this video 👍🏼⭐️⭐️⭐️🙏⭐️👍🏼
Won't be long Rekha...
Amazing... a lot of tips ! thanks!
Thank you.
How we can accommodate multiple project in same file or one file?? Also how multiple stakeholders can update their progress??
With Excel 365, you can place the file on onedrive or teams folders and others can update it. As the focus here is on one project, it would be tricky to add multiple in this format. See my other article for a project portfolio dashboard - chandoo.org/wp/design-project-portfolio-dashboard/
@@chandoo_ is it possible for your to shared actual locked excel template of PM dashboard
Hi Chandoo! this video is gold! I have 2 questions:
1.- is there a way to get the into the Gantt "in progress" tasks and
2.- how can we red flag delayed tasks?
Awesome stuff ...can't wait for your ADVANCED deck :)
Sir very informative. Can you help me link to download. Also can we show target vs Actual in Gantt chart ?
Thanks Sir really it will helpful to all of us👍
You are welcome Taizoon.
Great and simple, thanks alot
Glad you liked it!
Nice but very fast. Thankyou brother
You are welcome Sam.. may be you are on a 1.5 speed setting? Adjust the speed or pause the video at various points to take notes.
Hi, can you also include planned start and end dates along with Actual start and end dates. Also if the Gantt chart can show the highlights of the dates or the lag that is caused.
Thanks for the suggestions. I will consider these features when making v2.0 of the gantt chart.
Thank you very much. I will share it in my circle.
Thanks for the share.
Hi Chandoo, can you add 2 things in the gantt chart as per project requriement.
1. Plan dates & Actual dates
2. Critical pathes of the process.
Please advice
Thanks Nischal for the comments. Adding Plan vs. Actual view is straight forward. You can do it as a challenge.
Adding Critical path is tricky with Excel formulas alone. I suggest not using Excel for performing CPM / PERT analysis.
If i Arrange 3rd row in week format, how can i highlight current week similar to what you have used =J$3=TODAY()
Hi, I am having trouble with the AND function - it is not returning an TRUE values. - Mr. B
This is an awesome tutorial. Although, when the start and end dates on the 'people and data' page are empty (before starting a project for me), the pivot table removes the min/max columns. Is there any way I can keep these here even when the date fields are empty on the other table. Thanks!
Can I export this to google sheets and retain all the functionality. Thanks
Don't think so, but few others have asked about Google Sheets compatible dashboard. I will give it a try and make a video. Its going to be a while so be patient.
Sir, i dont have XLOOKUP function. how should i do fillling missing colums part?
You can use either VLOOKUP or INDEX+MATCH
I'll have watch from your first video to understand this rocket science
You won't regret the journey. Awesomeness to you.
@@chandoo_ sure
will go through all relevant latest videos as u’ve been doing this for a really long time
Great content…
Satisfying…
👉 *Read this If you have trouble with MIN & MAX dates* in Pivot tables:
This seems to a problem with Excel 2016. You can use Power Pivot measures to get the same result.
Right click on the table name in pivot table field list and select "add measure" option. Then name the measure as "start of activity" or something and use the =firstdate(activity[start date])
Do the same for max, but use the DAX formula =LASTDATE()
Isn’t the first row of date would show as #.?
If you add new activity would the link in the gantchart sheet got updated automatically?
You can hide that row or make it disappear with ;;; trick.
Once you add the activities, just hit REFRESH in data ribbon and they will flow to the dashboard.
Thank you man for this great work.
You are welcome Ben
Dumb question. We cant change the people? Love Batman - but where and how does this get done? Thanks Great sheet
Hi Matthew... You can do this by updating the people table and changing the task ownership in the activities table.
@@chandoo_ Many thanks - saved the day
I learned to apply multiple conditional formatting on single cell in which order matters.
Amazing, as usual!
Thank you Margarett.
question, what's the difference between infographic vs dashboard ? may be a dumb question but i been asking to create infographic in excel, i double check in youtube and it's the same as a dashboard, am i missing something ?
They are similar. In my book, infographic is something that is not usually interactive. So perfect for printing, presentations or emails. They are also designed like posters - ie engaging, often funky and tell a story.
Dashboards on the other hand are usually one page data stories that tend to be interactive and rich with data & insights. You can use either word for what I have shown in this video and it doesn't make a difference.
Hope that helps.
@@chandoo_ ty for your response.
Amazing, I’m definitely gonna use this bro
Thank you & Let me know how it goes...
Chandoo, Thank you for this video! is it possible to have 3 different teams (in my case architects, engineers and construction teams) then create projects or jobs for those teams as well as a actual team members for each job?
Hi Alex.. you can tweak this file to make such project plans. Alternatively, you can create a base version with all team & people data and then split to three files (and may be use Power Query to bring relevant data to each file) and use that to make the dashboards.
Chandoo, great video. Question regarding the section where you're changing the Count of Start to date(Min) Count of Finish(Max). I can't seem to apply that as on mine they are grayed out, please advise
Thanks Juan...
This seems to a problem with Excel 2016. You can use Power Pivot measures to get the same result.
Right click on the table name in pivot table field list and select "add measure" option. Then name the measure as "start of activity" or something and use the =firstdate(activity[start date])
Do the same for max, but use the DAX formula =LASTDATE()
Did you make it Juan?? I was not available to do it. 😢 my formula appears as wrong
Good work
Thank you...
Hi Chandu,
I want to make a project management tool where I can track development progress as like start date end date and followed by test plan start date and end date and finally test execution start date and end date by the resources and the team lead and would be great to filter by task IDs (development JIRA ID) by the client or multiple clients or all clients... Pls help
On top of this I need to create resources allocation where 1 tasks can be assigned to more than 5 or 6 persons for testing or development etc. Pls help
Hmm.. you may want to check my Project Management templates - chandoo.org/pmt/pmt-index-1.html
Not everything you mentioned is covered though.
Hi
I want to improve my Excel skills I have below average knowledge.
From Where do I start?
You are already at the right place. If you want a structured course, go for Excel School - chandoo.org/wp/excel-school-program
@@chandoo_ thank you for replying
Many thanks Chandoo
You are welcome Mehran
Except "Gantt chart" everything else sounded serious ;)
cheers
Thanks Ajay :) I like peppering my videos with a dad jokes 😅
@@chandoo_ You are really an adorable person. Totally original.
Hi Chandoo, I really appreciate the effort you put in, i downloaded your blank file and when i summarize by MIN it does not allow me to do it because startdate and enddate is not date data type, i tried to reformat the data to date type in activity table, but it does not work, hope you can help with this, Thank you !
Hi Minh... You are welcome :)
This seems to a problem with Excel 2016. You can use Power Pivot measures to get the same result.
Right click on the table name in pivot table field list and select "add measure" option. Then name the measure as "start of activity" or something and use the =firstdate(activity[start date])
Do the same for max, but use the DAX formula =LASTDATE()
@@chandoo_ Thank you, very clear instruction and easy to follow💯💯
On changing the date to min or max in pivot table it is showing error i.e. Cannot apply formula on text. Why and how to solve it?
Hi sir, how to make race bar graph in excel, can you post a tutorial TIA
If you are talking about animated race graphs that you see online, those are tricky to make in Excel and frankly not worth the effort.
If you mean something else, let me know what you have in mind.
@@chandoo_ thanks sir, If possible post a tutorial on this..
wow you are amazing explain
Thank you! 😃
Great video!
You are welcome Mohammed.
Hai bro! AND formula is not working while i'm trying to drag. What i did wrongly.
Hie Sir, do you have any real time example that how project scope and project planning for any project actually look like??? If you have , it will help me for my further studies and preparations
Unfortunately no Karan... I am not actively working in Project Management space anymore. I will share my thoughts next time I plan a big project.
Hi
Can you add weekends indicators & overdue indicators
Sure.. For a start, you can do this easily by adding conditional formatting rule to highlight weekends in dull color (just as we did for TODAY)
For overdue items, you can modify the ✅ rule and add a condition to show red flag when %done is
Hi chandoo, awesome video but please explain formulas which you use like xlookup and relationship bcoz I am not able to use this in Excel please...
Hi Sanjeev... please refer to the article here for a detailed tutorial of the dashboard. It has extra links on the individual bits too.
chandoo.org/wp/interactive-project-dashboard-with-excel/
Happy learning.
I am using the downloaded file, After creating the pivot table I am not able to summarize the dates by min and max. The min and max options are shown greyed out. Using excel 2016 desktop
This seems to a problem with Excel 2016. You can use Power Pivot measures to get the same result.
Right click on the table name in pivot table field list and select "add measure" option. Then name the measure as "start of activity" or something and use the =firstdate(activity[start date])
Do the same for max, but use the DAX formula =LASTDATE()
I realized I was using 2019 Version and XLOOKUP doesn't work, is there a alternative to this function
Sorry, xlookup is only available in 365 version. You can use good old vlookup or index match.
hello chandoo thanks for the videos and your website is filled with great lessons currently I''m working on excel form for daily production. which is for my manufacturing plant. and i learnt lot from you ... thank you once again . PEACE
This is amazing Chandoo!!! I just have a question. I have my Gantt Chart arranged in mmm-yy format, instead of your format. How do I highlight the current month column?
Thanks KLrishnan... Instead of =TODAY(), check for =AND(MONTH(date cell) = MONTH(TODAY()), YEAR(date cell) = YEAR(TODAY()))
@@chandoo_ Thanks so much Chandoo!! It worked :) but I didn't start my formula like how you showed in the video with =(date cell)= .... it wasnt working when i did that... it worked only when i started the formula with =AND(........) .... I hope that wont cause any issues...