This is very helpful. Thank you very much for the details in your video.

@excelexperthat

Жыл бұрын

You're very welcome!

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 !

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?

Exactly what I'm looking for, thank you so much. keep up the good work.

@excelexperthat

Жыл бұрын

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! :)

VERY NICELY EXPLAIND. REALLY AWSUM :) THANK YOU

Nicely done. Lots of information. Thanks for the help and guidance.

@excelexperthat

2 жыл бұрын

Thanks

It is a great tutorial!! Thanks!

@excelexperthat

Жыл бұрын

Glad it was helpful!

Super video

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()

its a great work.keep on

@excelexperthat

Жыл бұрын

Thank you, I will

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

@tysoncarmichael1663

2 жыл бұрын

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

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.

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

@excelexperthat

3 жыл бұрын

ok nice suggestion , will try this to cover in my next video, please

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?

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

Hi! How do I add more lines with overall timeline for example? And how I add one colored cell - planned end date?

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.

@excelexperthat

11 ай бұрын

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?

@excelexperthat

3 жыл бұрын

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

Are you can share the file for the trial?

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

@awmmook

2 жыл бұрын

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

@excelexperthat

2 жыл бұрын

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??

@excelexperthat

Жыл бұрын

Kindly check this video at 3:20 for Date formatting kzread.info/dash/bejne/gGhq0rKaoquoirA.html

Hi Expert, Can you please send me this excel sheet. 🙂

is it possible to link this gantt chart to ppt presentation?

@excelexperthat

Жыл бұрын

NO. You need to copy paste as picture

why my gantz chart didnt appeared when i used at 23:19 ?

@excelexperthat

Жыл бұрын

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

@excelexperthat

Жыл бұрын

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 "kzread.info/dash/bejne/gGhq0rKaoquoirA.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.