Gantt chart - Predecessor activity

%3CLINGO-SUB%20id%3D%22lingo-sub-1337541%22%20slang%3D%22en-US%22%3EGantt%20chart%20-%20Predecessor%20activity%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337541%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Excel%20community.%20Happy%20to%20join%20this%20forum.%20Recently%2C%20I%20came%20to%20know%20that%20Gantt%20chart%20can%20be%20prepared%20in%20Execl%20too%2C%20as%20we%20generate%20one%20in%20MS%20Project.%20Was%20looking%20for%20assigning%20predecessor%20activity%20for%20linking%20it%20with%20another%20task%20%2F%20row%20item.%20Request%20the%20forum%20to%20help%20me%20with%20tips%20%26amp%3B%20tricks%2C%20in%20this.%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1337541%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1337695%22%20slang%3D%22en-US%22%3ERe%3A%20Gantt%20chart%20-%20Predecessor%20activity%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337695%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F636788%22%20target%3D%22_blank%22%3E%40musuwathy%3C%2FA%3E%26nbsp%3B%20Here%20is%26nbsp%3Ba%20generic%20Gantt%20Chart%20excel%20template%20which%20can%20manage%20the%20inter-activity%20constratints%20by%20linking%20their%20start%20and%20end%20dates%20by%20simple%20%3D%20%3CCELL%3E%20or%20%3D%20%3CCELL%3E%20%2B%201%20formulas%20like%20shown%20below%20%3A-%3C%2FCELL%3E%3C%2FCELL%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20actual%20template%20is%20attached%20for%20download.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22amit_bhola_0-1587831308846.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186650i489D816338B7C58A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22amit_bhola_0-1587831308846.png%22%20alt%3D%22amit_bhola_0-1587831308846.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor

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

1 Reply
Highlighted

@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.

 

amit_bhola_0-1587831308846.png