Gantt chart query

[#1]

Hi guys

I need help

I'm making this gantt chart via 'recipe of gantt chart', but its pretty messed up. I've these tables;

• Project Names
• Project Codes
• Start Date
• End Date
• Milestones

            It involves;
               -Requirement Phase
               -Blueprints

                -Functional Requirement Done
                -Business requirement Blah Blah

• Milestone dates
• Project Status

          [whether it has been gone live, or dropped or Deployed]

•      Calender

So this is what I'm getting now

Though its a half screenshot. the expression i used was; max(End Date)-Min(Start Date) and i know this should not be not be the expression but the funniest part is i cant come up with a new expression.

All i want is something like that

The brown color representing that its first milestone has been completed yellow represents the second one, and the red represents the fourth milestone and if it gets go live then it gets all green. This all would be changing colors as per dates. idk how to achieve that but i want to achieve it.

Regards

[chaper]

Hi Rabia I am also looking for similar type Gantt Chart Requirement. Are you using Extension by ack or lms ??If you are using Adam's Extension.Can you share it ? or post in this thread? I was not able to download it.

Thanks in advance