Apr 25 2020 06:45 AM
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
Apr 25 2020 09:21 AM
@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.