Auto populating and increasing table/gantt chart

%3CLINGO-SUB%20id%3D%22lingo-sub-173115%22%20slang%3D%22en-US%22%3EAuto%20populating%20and%20increasing%20table%2Fgantt%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-173115%22%20slang%3D%22en-US%22%3EMorning%20All%2C%3CBR%20%2F%3E%3CBR%20%2F%3EApologies%20I'm%20not%20too%20sure%20on%20the%20terminology%20so%20don't%20know%20whether%20this%20has%20been%20asked%20before%20or%20what%20to%20refer%20to%20it%20as%20and%20struggling%20to%20find%20anything%20through%20Google.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20looking%20to%20create%20a%20Gantt%20chart%20in%20excel%20where%20the%20project%20list%20(rows)%20is%20fed%20by%20two%20tables%20(a%20local%20projects%20list%20and%20a%20national%20projects%20list)%20on%20a%20separate%20worksheet%20in%20the%20excel%20document.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20then%20like%20the%20calendar%20to%20be%20displayed%20by%20month%20but%20if%20possible%20I%20would%20like%20to%20then%20split%20each%20month%20by%20teams%20as%20I'm%20looking%20to%20show%20impact%20from%20each%20project%20on%20each%20team%20in%20any%20given%20month.%20I%20would%20like%20to%20have%20the%20division%20of%20teams%20in%20each%20month%20also%20fed%20from%20a%20separate%20table.%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20I%20am%20looking%20to%20create%20is%20a%20template%20where%20each%20area%20can%20input%20local%20projects%20and%20what%20teams%20they%20have%20in%20their%20areas%3B%20which%20would%20then%20automatically%20feed%20into%20the%20Gantt%20chart%20so%20that%20you%20could%20continually%20update%20team%20lists%20and%20projects%20list%20which%20would%20automatically%20adjust%20the%20Gantt%20chart%20or%20a%20separate%20tab.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20this%20possible%3F%20How%20would%20I%20even%20begin%3F!%20I%20have%20attached%20a%20brief%20sketch%20of%20what%20I%20am%20looking%20for%20which%20in%20case%20I%20have%20just%20rambled%20on!%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20in%20advance.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-173115%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-173307%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20populating%20and%20increasing%20table%2Fgantt%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-173307%22%20slang%3D%22en-US%22%3E%3CP%3EMicrosoft%20has%20a%20Template%20for%20Gantt%20Project%20Planning.%26nbsp%3B%20If%20you%20go%20to%20File%20%26gt%3B%20New%20%26gt%3B%20Type%20in%20Gantt%20project%20planner%20into%20the%20search%20box%20that%20says%20%22Search%20for%20online%20templates%22.%26nbsp%3B%20It%20won't%20be%20exactly%20what%20your%20looking%20for...but%20it%20should%20get%20you%20close.%26nbsp%3B%20The%20type%20of%20file%20you%20reference%20would%20need%20to%20be%20custom%20made...%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20765px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F30543iD97101F2249A654A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Gantt.png%22%20title%3D%22Gantt.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Morning All,

Apologies I'm not too sure on the terminology so don't know whether this has been asked before or what to refer to it as and struggling to find anything through Google.

I am looking to create a Gantt chart in excel where the project list (rows) is fed by two tables (a local projects list and a national projects list) on a separate worksheet in the excel document.

I would then like the calendar to be displayed by month but if possible I would like to then split each month by teams as I'm looking to show impact from each project on each team in any given month. I would like to have the division of teams in each month also fed from a separate table.

What I am looking to create is a template where each area can input local projects and what teams they have in their areas; which would then automatically feed into the Gantt chart so that you could continually update team lists and projects list which would automatically adjust the Gantt chart or a separate tab.

Is this possible? How would I even begin?! I have attached a brief sketch of what I am looking for which in case I have just rambled on!

Thanks in advance.
1 Reply

Microsoft has a Template for Gantt Project Planning.  If you go to File > New > Type in Gantt project planner into the search box that says "Search for online templates".  It won't be exactly what your looking for...but it should get you close.  The type of file you reference would need to be custom made...

 

Gantt.png