Forum Discussion

musuwathy's avatar
musuwathy
Copper Contributor
Apr 25, 2020

Gantt chart - Predecessor activity

Hi Excel community. Happy to join this forum. Recently, I came to know that Gantt chart can be prepared in Execl too, as we generate one in MS Project. Was looking for assigning predecessor activity for linking it with another task / row item. Request the forum to help me with tips & tricks, in this. Thanks

Charting
excel
Formulas and Functions
office 365

1 Reply

  • amit_bhola's avatar
    amit_bhola
    Iron Contributor
    Apr 25, 2020

    musuwathy  Here is a generic Gantt Chart excel template which can manage the inter-activity constratints by linking their start and end dates by simple = <cell> or = <cell> + 1 formulas like shown below :-

     

    The actual template is attached for download.

     

     

     

     

Resources