Excellent video it really help to clear my concepts of Gantt chart and how effectively we can prepare the same chart using MS excel tool too. Thankyou so much.
Thank you for such an easy and quick Gantt Chart technique in Excel. I have a question related to the above video. What if we want our project to start from Monday ? Also how can we highlight the weekends(Saturday & Sunday) and other holidays during the project tenure? Would appreciate if you can come up with a solution. Thanks once again for your efforts.
Challenge - I have sheet1, sheet2, sheet3, sheet4 and sheet5, every sheet contains date and time of the 12months, for example Sept. 09, I put an agenda on the 9am, then in sheet 2 I put agenda on 12nn, next sheet, 2pm, sheet 4 3pm and sheet 5 5pm. Then in Sheet 6 it shows all the activity I made on different sheet. I hove you notice my comments, because It is very big help to manage the class activity of 5 section handle. Thank you so much :) very helpful videos you always content :)
Hi, good work. I have 3 questions. 1) I would like to make friday as weekend, so in duration it will deduct Fridays. Saturday to Thursday are working days. 2) Highlightng bar for Actual, it doesnt get hilighted till we put end date. what i want to see is it highlight based till todays date from actual start, till i dont put end date. once i put end date, it should highlight from actual start to actual end date. 3) i want to add % colum, for plan and actual. Please assist me on this, appriciated.
Oh thank you very much bro for the shot valuable and educative video. I am still thinking about how to establish the critical path on the schedule? Thank you very much
Hi. That is what I'm looking for but to be 100% happy I looking to add for your planer some like: I'm handyman, Example I'm add kitchen project when I know that will be around 3 weeks. I want type kitchen on my task and excel should automatically mark this 3 weeks on my calendar. That will give me batter look of my free time to arrange next project. Are this criteria will be possible to put in your sheet. Thank you.
I've set up a Gantt Chart like the one you created and wonder now if it is possible to set up so that planned and actual duration can exclude weekend dates?
This is a great video. Can you explain how to level this schedule with available manning? For example; maybe you only have 4 people to complete all of these tasks.
This will only work if you have an actual finish date, how can you keep a running bar on the actual till its complete, for activities that have a longer duration. Like your tutorials, so informative and easy to follow.
@The Excel Challenge Thanks for your great advise. I have an excel challenge for the Gantt Chart. I wanna add the manpower in each cell with the conditional formatting and manpower graphic below the Gantt Chart. Please help me find a solution. :)
Hello. Thanks for the video. Do you have something similar but with tasks which are taking few hours, not days? I want to prepare something for my job, taking in consideration that i am working 8h/day and consider this 8h one day. Did you got my point? I want to track all my tasks and by the end of the month to see if I am doing my job better than the estimation. Let's say I estimate one task for 5h and i will finish in 4h, then I have cost saving for 1h. Thank you for your response!
hey, every time for a new activity, I have to copy formula for planned and actual row. is there any formula or coding like whenever a new activity adds up, formula itself applied to that row looking/searching for planned and actual keyword? do tell
hello sir, is there any formula which we can apply for the planned and actual row so that planned and actual formula ( X and Y )applied itself ,,we dont have to copy formula or to drag it ? please reply . its necessary.
Appreciate video content! Excuse me for the intrusion, I would love your thoughts. Have you heard the talk about - Weydaniel Organized Dominator (probably on Google)? It is a smashing one of a kind product for getting 7000 plus project management and business templates without the headache. Ive heard some amazing things about it and my work buddy after many years got cool results with it.
Thanks a lot for this video. SUPER USEFUL. One follow up Question though. Is it possible to highlight the amount a task slips in a different color(say RED) to flag the amount of delay in days ?, especially in the ACTUAL row. Sounds like this might need a slightly more complicated conditional formatting.
very good video, thanks for helping me to make my timeline, but just a doubt how does it work with two different months on the same timeline? as soon as i change the date it seems not to work. thanks
Thank you, please help me if there are multiple users in Project and their activities are not dependable, in such scenario can Grantt Chart helpful? What will be the other solution?
super thank you - i added this too to the Gantt chart - thank you. I was able to take out the weekend dates in the calender - but i dont know how i should do so that taskduration takes in conderation weekend dates - now if i have 3 days and 1 of them would fall on a saturday or sunday it doesnt show the 3th day - would be great to get some help on this too - in any case i am very thankfull for this video!
just going through your tutorials, which are great by the way; on this one (TECH-018 - Compare Estimated Time vs Actual Time in a Time Line (Gantt Chart) in Excel) how would you proceed to populate the chart, if you had one or more tasks that could be performed at the same time as others, meaning that they are not dependent one from each other? thank you in advance.
thanks for the video - just to clarify why did the formula calculate 6 days colored boxes when you enter 5 days - when you put 6 days - it colored 7 boxes
Thankyou for your tutorial.. it means a lot.. but can u help me, for controlling inventory, when to reorder, how long that inventory enough to use until it runs out..
Appreciate video content! Excuse me for the intrusion, I would love your thoughts. Have you heard the talk about - Weydaniel Organized Dominator (probably on Google)? It is a smashing one of a kind product for getting 7000 plus project management and business templates without the headache. Ive heard some amazing things about it and my work buddy after many years got cool results with it.
Hey Thanks for this video this is very Useful. But I should have need a bit more detailing in it, like I have to track the schedule and find out how many days I delay in my work, then how will they do it? Please can you Help me?
Hi - This is really good work! Is it also possible to show someway the dependencies in the Gantt chart which probably are or could block any activity and its impact on the baseline vs actual?
This excellent presentation, the demonstration is easy to understand!!! I learned a lot. What I want to know if we can combined the value of the actual completion in PERCENTAGES with same in the time line.
Hi sir, Your presentation is amazing but i notice something in your duration vs the number of bar which is not thesame for example in ID # 1 ,the duration is 4 but the bar showing is 5 which is not matching,what i did is i minus 1 in formula for the End date to have 4 bar .Thank you
Good morning, Is it possible to modify the conditional formatting to show 2 different colors in the same line. I.e. if a actual date goes past the planned the date could the overruns be colored "Red"? So on the 1 line the planned was 5 days and the actual was 8. The 3 additional days would be Red in color? Thanks and have a great day!
Hello Monus. The answer is YES. In my example I used an X if certain conditions are met and then I conditionality formatted X. Add conditions to your IF statement and use different letters, i.e. Y and then conditionally format Y, and so on and so forth. You follow? Trust this helps. T-E-CH
Good morning sir In place of dates. I have weeks to be created in column. Once I enter the date. It should show in which week does it come. I can share this file which I have
Thank you for your videos, they are really helping me put something together for work to make my life easier! Quick Question : How could I add promised delivery dates to show up on table? I would probably have a letter P rather than a colour as a colour would conflict. I have created a new cell with customer promised delivery dates but cannot get another IF fuction within the current.
Hello Mystery Mike and thank you for watching. I would probably follow the same idea that I used for X and Y and then I would insert a new row for the promise delivery dates using a P as you mentioned. You follow?
Hello and thank you for your reply :) . Yes I understand I could do this, however I was trying to avoid having another row. I wanted the P to appear in within the green or orange boxes (your sheet as example)- This would then be a quick reference to see whether you are meeting promised/request dates. I have created a new column with the customer promised date and tried doing another IF fuction within the existing but failed :( (e.g If (new column) show P)
That’s exactly what I was thinking: insert a new column called promised delivery dates. Please email me your file to theexcelchallenge@gmail.com and I’ll take a look at it and resend it to you.
Hello, thank you for showing this. Can you let me know how we can show time and date in the Gantt chart? I want to see a breakdown down to the time, but do not how to show that. Thank you
Hello, This tutorial is great! I'm wondering if there is a delay between tasks, how would I insert that information and it show up on the actuals line? Would I just insert rows? How would that change the formulas? Could these delays be made a different color?
Hello Lisanne. The answer is: All of the above!!! The customization of your spreadsheet is yours. If I had a delay in a task, all I would modify is the Duration column. For example, if the original was 3 days and it actually took 5, then say Duration = 5; that's your actual. Now, if the delay was in the Starting Date for example, just put the Actual Start Date, and voila! You can customize your sheet per your needs and that's what I encourage everybody to do. I only use examples in my videos to illustrate the idea. Just built from that platform and make your spreadsheet work per your needs. I hope your project goes well. T-E-CH
Is there any macro or formula to track a proyect progress in a daily or weekly basis? I mean, by coloring the days or weeks that are already gone. Regards
First of all, a big thanks to your informative video. A problem arose when I tried to insert project progress when comparing with using full duration and current work progress in my Gantt chart. As I wanted to put it in terms of conditional formatting, but I don't know how to insert it.
Hello Ankit. Sorry to hear it didn't work for you. Have you tried redoing the file following the procedure I showed in the video? It worked perfectly fine for me and I haven't heard similar comments. All I can tell you right now is "try again" but if you still have issues, send me your comments here. T-E-CH
I am one of the people who really thank you so much for your help and showing very clear steps. You the best
Thanks for your comment Salem. It’s nice to hear you find my videos helpful. Stay tuned for more.
Thanks for watching.
T-E-CH
how to we automatically exclude the weekend? let's say the allowed working days are monday to friday?
Thank you so much. This is one of the best tutorials ever.
Excellent video it really help to clear my concepts of Gantt chart and how effectively we can prepare the same chart using MS excel tool too. Thankyou so much.
This was probably the best Excel video I have seen, AWESOME!
I don't know how to thank you but the info you have put here was very great and from the bottom of my allow me say thank you very much.
Great solution. I´d spent ages trying to modify the IF(AND... formula, but couldn´t get it to work. So this is a really practical solution. Nice one.
Many thanks. It looks very professional and nice. I just followed your instruction to finish my report.
Thank you for such an easy and quick Gantt Chart technique in Excel. I have a question related to the above video. What if we want our project to start from Monday ? Also how can we highlight the weekends(Saturday & Sunday) and other holidays during the project tenure? Would appreciate if you can come up with a solution. Thanks once again for your efforts.
in actual condition, im working from monday to friday, could you tell me how to make off day on the timeline, and make calculate correctly sir ?
Challenge - I have sheet1, sheet2, sheet3, sheet4 and sheet5, every sheet contains date and time of the 12months, for example Sept. 09, I put an agenda on the 9am, then in sheet 2 I put agenda on 12nn, next sheet, 2pm, sheet 4 3pm and sheet 5 5pm. Then in Sheet 6 it shows all the activity I made on different sheet. I hove you notice my comments, because It is very big help to manage the class activity of 5 section handle. Thank you so much :) very helpful videos you always content :)
Hi, good work. I have 3 questions. 1) I would like to make friday as weekend, so in duration it will deduct Fridays. Saturday to Thursday are working days. 2) Highlightng bar for Actual, it doesnt get hilighted till we put end date. what i want to see is it highlight based till todays date from actual start, till i dont put end date. once i put end date, it should highlight from actual start to actual end date. 3) i want to add % colum, for plan and actual. Please assist me on this, appriciated.
Good video. How would you create one that avoids weekends and only does work M-F?
Superb really excellent Job to explain and is really very useful. Finally I got it . Thank You so much Bro!
Thank you very much for clear explanation.....very usefull video
One of the Top Rated Video.. great
Your videos are so helpful thank you!
You are a life saver bro! Thank you so much
Awesome thanks for sharing, this is going to great for my task list
Oh thank you very much bro for the shot valuable and educative video. I am still thinking about how to establish the critical path on the schedule?
Thank you very much
I Thank for your clear steps, my question is why we would add 1 on finish date to get the next start date?
Thank you so much for sharing this helpful tips！
this is your last video. I hope you comeback making videos because yours are better than the rest.
trust me I’ve checked them all.
Awesome , you made it look so easy,
You are life saver !!Thanks a ton.
Hi. That is what I'm looking for but to be 100% happy I looking to add for your planer some like:
I'm handyman,
Example I'm add kitchen project when I know that will be around 3 weeks. I want type kitchen on my task and excel should automatically mark this 3 weeks on my calendar. That will give me batter look of my free time to arrange next project. Are this criteria will be possible to put in your sheet.
Thank you.
Thank you so much for such clear instruction - and for the template...soooo useful!!!!
Thank you so much for this tutorials it is very helpful .How can we combine to create a yearly plan in one spreadsheet.
I've set up a Gantt Chart like the one you created and wonder now if it is possible to set up so that planned and actual duration can exclude weekend dates?
This is a great video. Can you explain how to level this schedule with available manning? For example; maybe you only have 4 people to complete all of these tasks.
This will only work if you have an actual finish date, how can you keep a running bar on the actual till its complete, for activities that have a longer duration. Like your tutorials, so informative and easy to follow.
hi. thanks for very helpful guide, but how to exclude the weekends? i already marked sundays as weekend
@The Excel Challenge Thanks for your great advise. I have an excel challenge for the Gantt Chart. I wanna add the manpower in each cell with the conditional formatting and manpower graphic below the Gantt Chart. Please help me find a solution. :)
Thank you Sooo much !! Thats sooo Awesomw !! Ofcourse I will try it
Hello. Thanks for the video. Do you have something similar but with tasks which are taking few hours, not days? I want to prepare something for my job, taking in consideration that i am working 8h/day and consider this 8h one day. Did you got my point? I want to track all my tasks and by the end of the month to see if I am doing my job better than the estimation. Let's say I estimate one task for 5h and i will finish in 4h, then I have cost saving for 1h. Thank you for your response!
Hi Sir! I really appreciate the tutorial ❤ Can you also make a video on how to apply Scurve for this ?
Exactly what I was looking for. Thank you.
I want to do this in Google sheets too. Don't know how it works out.
Impressive！Great to watch these videos👍😊
Please master, can one make the Plan Gantt chart run concurrently? eg. Two activities run at the same time. Thank you
You are a gem Sir!
is there a way to still include all Sundays? great video BTW!
hey,
every time for a new activity, I have to copy formula for planned and actual row. is there any formula or coding like whenever a new activity adds up, formula itself applied to that row looking/searching for planned and actual keyword? do tell
hi ' thanks for this amazing explanation ! what if I add a holydays and days off ?
Thank you for the very informative gantt chart but Please will you include a progress percent for this gantt chart.
hello sir,
is there any formula which we can apply for the planned and actual row so that planned and actual formula ( X and Y )applied itself ,,we dont have to copy formula or to drag it ? please reply . its necessary.
Thank you for the tutorial, I have a question, how do you automatically exclude weekends from Row 5? Hope you can help us with this one.
Appreciate video content! Excuse me for the intrusion, I would love your thoughts. Have you heard the talk about - Weydaniel Organized Dominator (probably on Google)? It is a smashing one of a kind product for getting 7000 plus project management and business templates without the headache. Ive heard some amazing things about it and my work buddy after many years got cool results with it.
Wow I wish you upload more..
Thanks a lot for this video. SUPER USEFUL. One follow up Question though. Is it possible to highlight the amount a task slips in a different color(say RED) to flag the amount of delay in days ?, especially in the ACTUAL row. Sounds like this might need a slightly more complicated conditional formatting.
Your methods are amazing and simple to implement, is there a way you create Critical path method(CPM) from project management point of view
very good video, thanks for helping me to make my timeline, but just a doubt how does it work with two different months on the same timeline? as soon as i change the date it seems not to work. thanks
Thank you very much.. can you help to show if we want to get percentage(%) for the planned vs actual? Thank you in advance..
Thank you, please help me if there are multiple users in Project and their activities are not dependable, in such scenario can Grantt Chart helpful? What will be the other solution?
super thank you - i added this too to the Gantt chart - thank you.
I was able to take out the weekend dates in the calender - but i dont know how i should do so that taskduration takes in conderation weekend dates - now if i have 3 days and 1 of them would fall on a saturday or sunday it doesnt show the 3th day - would be great to get some help on this too - in any case i am very thankfull for this video!
just going through your tutorials, which are great by the way; on this one (TECH-018 - Compare Estimated Time vs Actual Time in a Time Line (Gantt Chart) in Excel) how would you proceed to populate the chart, if you had one or more tasks that could be performed at the same time as others, meaning that they are not dependent one from each other? thank you in advance.
Thanks for this. But how best can you help me as a beginner? I have a project assignment for a duration of 15months. It's a construction project
thanks for the video - just to clarify why did the formula calculate 6 days colored boxes when you enter 5 days - when you put 6 days - it colored 7 boxes
this is very helpful. thank you very much. makes my work easier so much.
Sir I appreciate you're hardwork, you are doing very will, Sir I kindly request u to create a tracking sheet for expenses of a project.
Question: Is there a way to remove the weekend dates in Row 5 so only workdays are listed? Great videos, very helpful!
I was also thinking about this question... It would be a salvation for me and the team of our department.
Thank you... This is the Idea I was looking for...
Thank you for sharing. can you show sample of FTTH fiber deployment template ?
Great videos!!! Looking forward that you make more of them =)
Thankyou for your tutorial.. it means a lot..
but can u help me, for controlling inventory, when to reorder, how long that inventory enough to use until it runs out..
Thanks this video is really helpful
Appreciate video content! Excuse me for the intrusion, I would love your thoughts. Have you heard the talk about - Weydaniel Organized Dominator (probably on Google)? It is a smashing one of a kind product for getting 7000 plus project management and business templates without the headache. Ive heard some amazing things about it and my work buddy after many years got cool results with it.
Hey Thanks for this video this is very Useful.
But I should have need a bit more detailing in it, like I have to track the schedule and find out how many days I delay in my work, then how will they do it?
Please can you Help me?
Excellent! How can we adjust the formula to make more than 1 “start/end” date in the same row. Please help!
You saved my absolute bacon. Thank you sir!
I want to be able to use hours and minutes with dates. I'm using it to track manufacturing processes.
Hope you find solutions
Thank you >>>> How can Add or show progress bar ?
Can we add the progress percentage to the Gantt chart along with the responsible person
Hi - This is really good work! Is it also possible to show someway the dependencies in the Gantt chart which probably are or could block any activity and its impact on the baseline vs actual?
Amazing❤
What would be the quickest way to do this by hours instead of days?
is there any softwre to do this beside excel? i cant find gann chart app that includes plan vs actual
Try my video TECH-018 at theexcelchallenge.com/
This excellent presentation, the demonstration is easy to understand!!! I learned a lot.
What I want to know if we can combined the value of the actual completion in PERCENTAGES with same in the time line.
Actually helpful.
Nice...Please make a video on Daily, weekly and monthly plaaner in xls.
This was very useful, thank you!
Hello..Please how do I assig resources using this Gantt Chart you created?
Why are you not active nowadays..?
You're doing great brother..!
Can you explain please why do we see 2 blocks in the time line for a duration of one day?
Hi sir,
Your presentation is amazing but i notice something in your duration vs the number of bar which is not thesame for example in ID # 1 ,the duration is 4 but the bar showing is 5 which is not matching,what i did is i minus 1 in formula for the End date to have 4 bar .Thank you
Thank you. much helpful..
Wow it is great but can you please post example this table weekly plan vs actual
Good morning,
Is it possible to modify the conditional formatting to show 2 different colors in the same line.
I.e. if a actual date goes past the planned the date could the overruns be colored "Red"? So on the 1 line the planned was 5 days and the actual was 8. The 3 additional days would be Red in color?
Thanks and have a great day!
Hello Monus. The answer is YES. In my example I used an X if certain conditions are met and then I conditionality formatted X. Add conditions to your IF statement and use different letters, i.e. Y and then conditionally format Y, and so on and so forth. You follow?
Trust this helps.
T-E-CH
Thanks for the video. So helpful
I am finding it difficult to create timeline between two 4 months using a weekly interval. Can you help me please?
Good morning sir
In place of dates. I have weeks to be created in column. Once I enter the date. It should show in which week does it come. I can share this file which I have
Can you show how to toggle with prev and next button if there is several months and years??
Thank you for your videos, they are really helping me put something together for work to make my life easier!
Quick Question : How could I add promised delivery dates to show up on table?
I would probably have a letter P rather than a colour as a colour would conflict. I have created a new cell with customer promised delivery dates but cannot get another IF fuction within the current.
Hello Mystery Mike and thank you for watching. I would probably follow the same idea that I used for X and Y and then I would insert a new row for the promise delivery dates using a P as you mentioned. You follow?
Hello and thank you for your reply :) . Yes I understand I could do this, however I was trying to avoid having another row. I wanted the P to appear in within the green or orange boxes (your sheet as example)- This would then be a quick reference to see whether you are meeting promised/request dates. I have created a new column with the customer promised date and tried doing another IF fuction within the existing but failed :( (e.g If (new column) show P)
That’s exactly what I was thinking: insert a new column called promised
delivery dates. Please email me your file to theexcelchallenge@gmail.com and I’ll take a look at it and resend it to you.
Awesome XD
MisterMyke R i want make in visual basics Lingo ball game
can you tell me how to do this
great job
You are in my mind, thank you
Thanks Arteo. Glad you liked it.
Hello. How to set a predecessor activity and also show float ?
Hello this indeed the simplest and nice tutorial.
Can we also add holiday and workday information ??
Instead of End-start, you can use workday/workday.int formula ...
Hello, thank you for showing this. Can you let me know how we can show time and date in the Gantt chart? I want to see a breakdown down to the time, but do not how to show that. Thank you
Thanks for this excellent video.
How can we change time frame from days to weeks (W1, W2, W3, W4)?
that's my question too please answer.. thank you
do u have construction schedule
This is awesome
Can links be included to create critical paths?
Hello, This tutorial is great! I'm wondering if there is a delay between tasks, how would I insert that information and it show up on the actuals line? Would I just insert rows? How would that change the formulas? Could these delays be made a different color?
Hello Lisanne. The answer is: All of the above!!!
The customization of your spreadsheet is yours. If I had a delay in a task, all I would modify is the Duration column. For example, if the original was 3 days and it actually took 5, then say Duration = 5; that's your actual.
Now, if the delay was in the Starting Date for example, just put the Actual Start Date, and voila! You can customize your sheet per your needs and that's what I encourage everybody to do. I only use examples in my videos to illustrate the idea.
Just built from that platform and make your spreadsheet work per your needs.
I hope your project goes well.
T-E-CH
Is there any macro or formula to track a proyect progress in a daily or weekly basis? I mean, by coloring the days or weeks that are already gone. Regards
First of all, a big thanks to your informative video. A problem arose when I tried to insert project progress when comparing with using full duration and current work progress in my Gantt chart. As I wanted to put it in terms of conditional formatting, but I don't know how to insert it.
Hello Ankit.
Sorry to hear it didn't work for you. Have you tried redoing the file following the procedure I showed in the video? It worked perfectly fine for me and I haven't heard similar comments. All I can tell you right now is "try again" but if you still have issues, send me your comments here.
T-E-CH