This is great. I remember completing this exercise when you uploaded it earlier. I remember including public holidays amongst the weekends. For instance I formatted it so the Easter weekend, ANZAC Day & the Queensland Labor Day blocked out.
This is an excellent piece of work. The dynamism from date / week / month is super fantastic. I could not understand the logic behind the yet to start, in-progress and completed work formula. However, it is working as expected when we switch from Days/weeks/months view. Super. Just one more help required. In actual we cannot follow what has been planned. Can we chart following details also. 1. Planned (start to end) in one colour / fill/ pattern (it is actually there in the Excel) 2. Actual (Start to expected end) in another colour / fill / pattern 3. % Completed in differect colour (it is actually there in the Excel) 4. Actual beyond planned in another colour / fill / pattern 5. % Completed beyond planned in different colour / fill / pattern Really appreciate for your highly learning videos. THANK YOU VERY MUCH FROM DEEPEST OF MY HEART.
Glad you found it useful! You can add more formats if you like. You might find this tutorial on writing conditional format formulas helpful: th-cam.com/video/Rzz9PyfwiVQ/w-d-xo.html
Top draw as always very impressive. Could also be used to develop forecasting columns i.e four / five weekly forecasts generate the monthly forecast . Thank you
Thank you so much for the Great Video. It was very helpful and you explained it really well.however i have a question and that is that no Progress is necessary in my table. I just want to have the Tasks displayed over time without differentiating between different progresse. So i would Like to have the tasks also in Daily view,weekly view and monthly without any Progress
Thank you for the excellent training and share your experience. Can you help with one point? How can I see days completed and Progress per project in the table when I swap all projects and do not see tasks?
Glad it was helpful! Regarding your question, I'm not sure what you mean. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
Hi your work is awesome and help me develop my dashboard for work do you do a schedule health dashboard tutorial you are so informative and easy learning what a skill you have..thanks for all your help
Thanks for your kind words! I don't have a health dashboard tutorial, however my Excel Dashboard course will teach you the skills so you can build any dashboard: www.myonlinetraininghub.com/excel-dashboard-course
Really excellent dashboard thanks. One issue I’ve found is the scroll bar still only increases by 1 day in whichever display period used. Is there a way to vary the increment of the scroll bar?
It works for the DailyDates and WeeklyDates, but the MonthlyDates needs modifying as follows: =LET( DailyDates, SEQUENCE(1,26,MIN(Table1[Start Date])+ScrollPos,1), WeeklyDates,SEQUENCE(1,26,MIN(Table1[Start Date])+ScrollPos,7), MonthlyDates,DATE(MIN(YEAR(Table1[Start Date])),SEQUENCE(,26,1)+ScrollPos,1), CHOOSE(DisplayPeriod, DailyDates, WeeklyDates, MonthlyDates))
Thank you so much for this video, you are truly amazing! One question - is there a way for the Gantt chart to display different information? I would like to understand resource capacity per team member for each project. So for example, "team member X worked 4 hrs on project Y and 2 hrs on Project Z on Monday". Is this possible to do/how should I format this data to properly display? Thank you in advance for any guidance.
Really brilliant 👌Thank you very much! It would be AMAZING if you would create a video how we can use Dynamic Periods in a barchart or a line char. So that the user can choose if the x - axis , show the years or month or Weeks. 🙌🏼🙌🏼 I try it since days in excel, but without any results 😭 Please help ❤
Hi First of all this is amazing and thank you so much for helping us. I have 1 question : When I add more rows for example 100 rows but this chat only show 45 rows data on the right side. Can you please help here ? Thank you
Great to hear it's helpful! As long as you add more rows to the source data table and then Refresh the PivotTable, it will automatically include the new rows.
Thank you so much for your reply I am sorry if i could not explain clearly Rows are showing after adding more but the graph is not showing in front of those new rows. Graph only showing for 46 rows same as your template. Please help @@MyOnlineTrainingHub
Hi Mynda, Great Video! However, when I test my formulas for completed/in-progress in the cells they are evaluating. But when I go to add this as a conditional formatting rule Excel is telling me there is an 'error' with the formula. Any thoughts or ideas?
Hard to say without seeing it. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
Quick question Mynda, Using this Tabular design, I'm having trouble getting the sort order for each of my projects, by Start Date. I tried sorting by in a bunch of ways in the Pivot table, but having no luck so far. For now, I was able to fudge it with putting a number before my task's verbiage. I'm my case, i have task's that are more verbose than "Task1, Task 2 etc.." Any tips would be greatly appreciated. Best Regards!
Hi. First and foremost, thank you Mynda for this fantastic Dashboard! Gerat job! One kind request....Can you please (or somebody from the comment section) paste the last "conditional formating" formula for the MonthsFormat in a reply to this comment?? This would save my life :) I can see the three OR condition for the MonthsFormat conditional formating in the video but i cannot see what are the changes made for the Days and Weeks format. Thus i am unable to make the formula work and can not complete my personal dashboard :(((((((((((....Thanks in advance!
Excellent Mynda. Small works of art that make up a great work of art. Thank you.
Thanks so much, Ivan!
I love your way of typing the conditional formatting formula in the cell first and the use of sequence in the time functions!!
Nice to know you'll find that useful 😊
Brilliant! You make the difficult easy, as usual. Thanks!
Thanks for your kind words 😊
This is great. I remember completing this exercise when you uploaded it earlier.
I remember including public holidays amongst the weekends. For instance I formatted it so the Easter weekend, ANZAC Day & the Queensland Labor Day blocked out.
Nice addition for the public holidays 👍
Thanks Mynda, simply explained & brilliant as always.
Thanks so much 😊
You are BRILLIANT! I love your way of explaining and this updated version is super dynamic and exactly what i need ! Thank you for being amazing!
Thank you! So pleased it was helpful!
Very impressive Mynda, thanks! Another great video..
Cheers, Chris 🙏
Learned a lot Mynda. Thanks!
Great to hear 🙏
Thumbs up shared and downloaded. Jedi level excel skills. Thank you for sharing your knowledge and imagination with us
Thanks so much 😊
Brilliant! Thank you for sharing.
Appreciate that 🙏
Amazing! Thank you!
Cheers 🙏
Brilliant and nice work !! Thanks!!!
Thanks so much!
Excel t-shirt is back! Great tutorial Mynda.
😁momentarily!
You are Amazing!!! Thank you very much for very interesting videos.
Thanks so much, Eduard!
Love it. Thank you
Glad you enjoyed it!
This is very helpful
Glad to hear!
This is an excellent piece of work. The dynamism from date / week / month is super fantastic. I could not understand the logic behind the yet to start, in-progress and completed work formula. However, it is working as expected when we switch from Days/weeks/months view. Super.
Just one more help required. In actual we cannot follow what has been planned. Can we chart following details also.
1. Planned (start to end) in one colour / fill/ pattern (it is actually there in the Excel)
2. Actual (Start to expected end) in another colour / fill / pattern
3. % Completed in differect colour (it is actually there in the Excel)
4. Actual beyond planned in another colour / fill / pattern
5. % Completed beyond planned in different colour / fill / pattern
Really appreciate for your highly learning videos. THANK YOU VERY MUCH FROM DEEPEST OF MY HEART.
Glad you found it useful! You can add more formats if you like. You might find this tutorial on writing conditional format formulas helpful: th-cam.com/video/Rzz9PyfwiVQ/w-d-xo.html
Top draw as always very impressive. Could also be used to develop forecasting columns i.e four / five weekly forecasts generate the monthly forecast . Thank you
Yes, great idea 👍
Awesome!
Thank you! 😊
👌🏻 Like your work 💯
Thank you!
I love you momm ..thank u so much
Most welcome 😊
Thank you so much for the Great Video. It was very helpful and you explained it really well.however i have a question and that is that no Progress is necessary in my table. I just want to have the Tasks displayed over time without differentiating between different progresse. So i would Like to have the tasks also in Daily view,weekly view and monthly without any Progress
Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
Thank you for the excellent training and share your experience. Can you help with one point? How can I see days completed and Progress per project in the table when I swap all projects and do not see tasks?
Glad it was helpful! Regarding your question, I'm not sure what you mean. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
Hi your work is awesome and help me develop my dashboard for work do you do a schedule health dashboard tutorial you are so informative and easy learning what a skill you have..thanks for all your help
Thanks for your kind words! I don't have a health dashboard tutorial, however my Excel Dashboard course will teach you the skills so you can build any dashboard: www.myonlinetraininghub.com/excel-dashboard-course
Really excellent dashboard thanks. One issue I’ve found is the scroll bar still only increases by 1 day in whichever display period used. Is there a way to vary the increment of the scroll bar?
It works for the DailyDates and WeeklyDates, but the MonthlyDates needs modifying as follows:
=LET(
DailyDates, SEQUENCE(1,26,MIN(Table1[Start Date])+ScrollPos,1),
WeeklyDates,SEQUENCE(1,26,MIN(Table1[Start Date])+ScrollPos,7),
MonthlyDates,DATE(MIN(YEAR(Table1[Start Date])),SEQUENCE(,26,1)+ScrollPos,1),
CHOOSE(DisplayPeriod,
DailyDates,
WeeklyDates,
MonthlyDates))
Thank you so much for this video, you are truly amazing! One question - is there a way for the Gantt chart to display different information? I would like to understand resource capacity per team member for each project. So for example, "team member X worked 4 hrs on project Y and 2 hrs on Project Z on Monday". Is this possible to do/how should I format this data to properly display? Thank you in advance for any guidance.
Yes, you can modify this technique to work with different data. I don't have any examples I can point you to though, sorry.
Really brilliant 👌Thank you very much! It would be AMAZING if you would create a video how we can use Dynamic Periods in a barchart or a line char. So that the user can choose if the x - axis , show the years or month or Weeks. 🙌🏼🙌🏼 I try it since days in excel, but without any results 😭 Please help ❤
Great suggestion!
That would be wonderful 👏👏👏@@MyOnlineTrainingHub
Amazing tutorial except too quick to follow. Plus, I need to upgrade my 2019 version. Thanks a lot!!
Please try the play back speed options in the video settings (cog icon) to slow it down.
Hi
First of all this is amazing and thank you so much for helping us.
I have 1 question : When I add more rows for example 100 rows but this chat only show 45 rows data on the right side.
Can you please help here ? Thank you
Great to hear it's helpful! As long as you add more rows to the source data table and then Refresh the PivotTable, it will automatically include the new rows.
Thank you so much for your reply
I am sorry if i could not explain clearly
Rows are showing after adding more but the graph is not showing in front of those new rows.
Graph only showing for 46 rows same as your template.
Please help
@@MyOnlineTrainingHub
Thanks Mynda, great video. But my brain hurts now!!
😁mine hurt writing those formulas! But I'd been asked so many times for this, I finally caved!
Hi Mynda, Great Video! However, when I test my formulas for completed/in-progress in the cells they are evaluating. But when I go to add this as a conditional formatting rule Excel is telling me there is an 'error' with the formula. Any thoughts or ideas?
Hard to say without seeing it. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
Quick question Mynda, Using this Tabular design, I'm having trouble getting the sort order for each of my projects, by Start Date. I tried sorting by in a bunch of ways in the Pivot table, but having no luck so far. For now, I was able to fudge it with putting a number before my task's verbiage. I'm my case, i have task's that are more verbose than "Task1, Task 2 etc.." Any tips would be greatly appreciated. Best Regards!
If you want to sort by date, then that field needs to be the first column in your PivotTable.
@@MyOnlineTrainingHub Thank you Mynda
👍👍👍👍👍👍👍👍👍
Cheers!
Hi. First and foremost, thank you Mynda for this fantastic Dashboard! Gerat job!
One kind request....Can you please (or somebody from the comment section) paste the last "conditional formating" formula for the MonthsFormat in a reply to this comment?? This would save my life :)
I can see the three OR condition for the MonthsFormat conditional formating in the video but i cannot see what are the changes made for the Days and Weeks format. Thus i am unable to make the formula work and can not complete my personal dashboard :(((((((((((....Thanks in advance!
Glad it was helpful! You can download the completed file from the link in the video description 😉
Isn't this Microsoft Project?
This is for those who don’t have MS Project 😉