thank you so much ! this was really really helpful.. you explained the entire workflow so well that a beginner like me was able to follow ! thank you so much once again !
Thank you for the video and detailed explanation for each step. It was very useful for my use case and I could easily follow what you did. Keep it up! :)
Everything worked perfectly! Do you have a suggestion for a conditional formatting formula signifying actual start date through duration of days, rather than an end date? Or how can I edit the current actual duration formula to not show until the end date is populated?
Great video brother, really helped me out! I had a couple of questions. ` 1.Is there a way to add milestones on gantt chart? such a project Go-Live? 2. Can you add the formulas you used on the custom formatting rules to the description? It is a little hard to see on the video. Thanks for everything
Hey Sachneet, I implemented milestones in my chart using a color code. On my sheet, I included a column called highlighted color. Under this columns, I added a few color options: blue, amber, green. Then in the conditional formatting, I repeated the same formula (used to compare the dates) three times. One for each color. Here's how that formula looks: =AND(S$2>=$M3,S$2=$M3,S$2=$M3,S$2
In my excel, the gantt chart formula is not working. I mean the color bar is not showing when I applied conditional formatting according to your video. Pls help me out
Hi, i have a problem where the formula does not want to be registrerd as a formula.. wont let me show the lines for the current date : =AND(TODAY()>=G$15,TODAY()
Hi, thank you for the detailed description. I had a question. How do I sort my project plan using dates instead of task name? Currently the project plan is sorted using tasks so tasks such as Acceptance testing comes to the top of the table
a nice to have feature on this would be way to automatically identify those tasks which "actual end date" has past the "planned end date" by filling in the overlapping gantt chart bar in red or yellow
What is the conditional format formulae where the startdate and enddate = 1 day? I can not seem to get this populate =IF(AND($D7=H$6),1,"") Start Date (14/07/23) [D7] Finish Date (14/07/23) [E7] Date (today 14/07/23) [G6] Date (tomorrow 15/07/23) [H6] Many thanks
Hello... this was really helpful and easy to follow. I would like to sort the chart but the planned start date but it doesnt seem to be working. Can you give some advice?
hi, do you know how can i arrange the tasks/activities from oldest to newest date? cause even if i sort the table with START column, it does not arrange.
This is a very useful inforamtion. By any chance, do you have a version that creates the bars for mutiple phass in the project such as Requirements Dev, QA, Deployment etc.
Great! there's one thing . . . setting the days to 1 works fine, but setting the days to 7 (for example) the end of bar isn't ending in the correct ending collumn. Well, based on the formatting it is, but it shows a bit weird
May be better use this formula for the bars: =IF(AND($C15=F$14);1;"") So evaluate the enddate also to the same cell as for evaluation of the startdate, F14. Then the bars end in the correct collumn no matter the calenderinterval in days you enter
There are many reason 1. Your area of cell selection for conditional formatting 2. Your date selection or date format or date cell issue some times 3. Your formula might have an error
Thanks for your Feeback. Can you let us know at which minute: Sec you haven't seen the formula in the video. Might be you haven't checked out the "ruclips.net/video/N46pParHBZM/видео.html" Ultimate Gantt Chart video which shows all the basic formulas used in this video. This Video is for advance users. So we request you to check the given video first and then come back to this video. Thanks.
thank you so much !
this was really really helpful..
you explained the entire workflow so well that a beginner like me was able to follow !
thank you so much once again !
This is very helpful. Thank you very much for the details in your video.
You're very welcome!
Exactly what I'm looking for, thank you so much. keep up the good work.
Thanks
Thank you for the video and detailed explanation for each step. It was very useful for my use case and I could easily follow what you did. Keep it up! :)
Nicely done. Lots of information. Thanks for the help and guidance.
Thanks
VERY NICELY EXPLAIND. REALLY AWSUM :) THANK YOU
Everything worked perfectly! Do you have a suggestion for a conditional formatting formula signifying actual start date through duration of days, rather than an end date? Or how can I edit the current actual duration formula to not show until the end date is populated?
It is a great tutorial!! Thanks!
Glad it was helpful!
Great video brother, really helped me out! I had a couple of questions. `
1.Is there a way to add milestones on gantt chart? such a project Go-Live?
2. Can you add the formulas you used on the custom formatting rules to the description? It is a little hard to see on the video.
Thanks for everything
Hey Sachneet, I implemented milestones in my chart using a color code. On my sheet, I included a column called highlighted color. Under this columns, I added a few color options: blue, amber, green. Then in the conditional formatting, I repeated the same formula (used to compare the dates) three times. One for each color. Here's how that formula looks: =AND(S$2>=$M3,S$2=$M3,S$2=$M3,S$2
In my excel, the gantt chart formula is not working. I mean the color bar is not showing when I applied conditional formatting according to your video. Pls help me out
Super video
Hi, i have a problem where the formula does not want to be registrerd as a formula.. wont let me show the lines for the current date : =AND(TODAY()>=G$15,TODAY()
Hi,
thank you for the detailed description. I had a question. How do I sort my project plan using dates instead of task name? Currently the project plan is sorted using tasks so tasks such as Acceptance testing comes to the top of the table
a nice to have feature on this would be way to automatically identify those tasks which "actual end date" has past the "planned end date" by filling in the overlapping gantt chart bar in red or yellow
ok nice suggestion , will try this to cover in my next video, please
What is the conditional format formulae where the startdate and enddate = 1 day? I can not seem to get this populate
=IF(AND($D7=H$6),1,"")
Start Date (14/07/23) [D7]
Finish Date (14/07/23) [E7]
Date (today 14/07/23) [G6]
Date (tomorrow 15/07/23) [H6]
Many thanks
its a great work.keep on
Thank you, I will
Hello... this was really helpful and easy to follow. I would like to sort the chart but the planned start date but it doesnt seem to be working. Can you give some advice?
Hi! How do I add more lines with overall timeline for example? And how I add one colored cell - planned end date?
hi, do you know how can i arrange the tasks/activities from oldest to newest date? cause even if i sort the table with START column, it does not arrange.
This is a very useful inforamtion. By any chance, do you have a version that creates the bars for mutiple phass in the project such as Requirements Dev, QA, Deployment etc.
Kindly check my other video on Gantt chart where we can categories the Bars color as per task.
also how did you merge the cells in the pivot table after "insert blank line after each item" you didn't show in video?
Go to
"Design -> Blank Rows -> Insert Blank Line after Each Item"
any hero that has the file finished? I had so many problems trying to follow up
Great! there's one thing . . . setting the days to 1 works fine, but setting the days to 7 (for example) the end of bar isn't ending in the correct ending collumn. Well, based on the formatting it is, but it shows a bit weird
May be better use this formula for the bars: =IF(AND($C15=F$14);1;"")
So evaluate the enddate also to the same cell as for evaluation of the startdate, F14. Then the bars end in the correct collumn no matter the calenderinterval in days you enter
YEs it is, if you make the days 7 and working days are less than 7 then it shows a weird results. will work on that and reply if possible.
How did you insert the dates around 10:20 into the video??
Kindly check this video at 3:20 for Date formatting ruclips.net/video/N46pParHBZM/видео.html
Are you can share the file for the trial?
is it possible to link this gantt chart to ppt presentation?
NO. You need to copy paste as picture
Hi Expert, Can you please send me this excel sheet. 🙂
why my gantz chart didnt appeared when i used at 23:19 ?
There are many reason
1. Your area of cell selection for conditional formatting
2. Your date selection or date format or date cell issue some times
3. Your formula might have an error
you are not showing all the formula and its useless
Thanks for your Feeback. Can you let us know at which minute: Sec you haven't seen the formula in the video. Might be you haven't checked out the "ruclips.net/video/N46pParHBZM/видео.html" Ultimate Gantt Chart video which shows all the basic formulas used in this video. This Video is for advance users. So we request you to check the given video first and then come back to this video. Thanks.