Gantt Chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1356314%22%20slang%3D%22en-US%22%3EGantt%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356314%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi.%20I%20have%20created%20a%20dailywise%20progress%20report%20of%20a%20project%20using%20conditional%20formatting%20for%20estimated%20and%20actual%20progresses.%20The%20project%20is%20of%20approx%206%20months%20duration.%20The%20project%20being%20a%20lengthy%20one%2C%20it%20is%20not%20possible%20to%20print%20the%20whole%20progress%20in%20a%20single%20page.%20For%20that%20purpose%2C%20I%20have%20created%20a%20dynamic%20calendar%20showing%2012%20months%20at%20a%20time%20upto%20the%20year%202049%20in%20the%20next%20worksheet.%20Now%20I%20am%20unable%20to%20use%20any%20formula%20across%20these%20two%20worksheet.%20My%20aim%20was%20that%20the%20calculations%20in%20the%20first%20sheet%20(Actual)%20will%20be%20displayed%20in%20the%20calendar%20of%202nd%20sheet%20as%20colour%20fill%20just%20like%20the%20first%20sheet.%20The%20first%20month%20and%20year%20of%20the%20calendar%20should%20be%20automatically%20selected%20from%20the%20start%20date%20of%20project%20(from%20the%20first%20sheet)%2C%20so%20that%20the%20total%20progress%20can%20be%20be%20shown%20in%20single%20page%20itself.%20Additionally%20suggest%20me%20how%20can%20I%20create%20a%20database%20for%20such%20multiple%20projects%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1356314%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1356719%22%20slang%3D%22en-US%22%3ERe%3A%20Gantt%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356719%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F645949%22%20target%3D%22_blank%22%3E%40lodhnerist%3C%2FA%3E%26nbsp%3B%2C%20Hi%3C%2FP%3E%3CP%3ESorry%20if%20i%20may%20not%20be%20addressing%20your%20specific%20issue%2C%20but%20i%20gather%20that%20your%20%3CEM%3Emain%20intent%3C%2FEM%3E%20is%20%3CEM%3Eto%20be%20able%20to%20make%20a%20Gantt%20chart%20for%20a%20long%20project%20which%20is%20easy%20to%20print%20on%20single%20page.%3C%2FEM%3E%3C%2FP%3E%3CP%3EConsider%20making%20the%20Plan%20vs.%20Actual%20sheet%20itself%20a%20bit%20flexible%20in%20terms%20of%20%22Step%20Days%22%20so%20that%20you%20need%20not%20think%20about%20the%20calendar%20view%20at%20all.%3C%2FP%3E%3CP%3EI%20was%20able%20to%20make%20such%20a%20flexible%20template%20in%20which%20you%20may%20print%20status%20of%20a%20long%20project%20on%201%20page.%3C%2FP%3E%3CP%3EAttaching%20it%20for%20your%20reference%2C%20so%20that%20it%20may%20give%20you%20some%20hint%20%2F%20clue.%20If%20it%20helps!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhen%20step%20days%20is%201%20%3A-%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-1588561136759.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%2F188556iCAD051F43B883059%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22amit_bhola_0-1588561136759.png%22%20alt%3D%22amit_bhola_0-1588561136759.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20when%20step%20days%20%3D%207%20(week)%20%2C%20the%20shedule%20shrinks%20%3A-%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22amit_bhola_1-1588561205474.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%2F188557iC8982AC13D6271F5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22amit_bhola_1-1588561205474.png%22%20alt%3D%22amit_bhola_1-1588561205474.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1381718%22%20slang%3D%22en-US%22%3ERe%3A%20Gantt%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1381718%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20a%20lot%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F636579%22%20target%3D%22_blank%22%3E%40amit_bhola%3C%2FA%3E%20I%20think%20it%20will%20work%20for%20me%20for%20this%20project.%20But%20not%20getting%20how%26nbsp%3B%20to%20include%20stepdays%20in%20my%20Chart.%20Will%20you%20please%20suggest.%20I%20have%20already%20included%20weekend%20using%20NETWORKDAYS.INTL.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGuide%20for%20my%20chart%3A%3C%2FP%3E%3CP%3EIf%20you%20go%20through%20my%20chart%20i%20think%20u%20will%20get%20it%2C%20where%20D6%20is%20the%20only%20input%20for%20the%20plan%20(Estimated)%20and%20whereas%20D7%2C%20E7%2C%20D9%2C%20E9%2C%20D11%2C%20E11%2C%20..............%20D27%2C%20E27%20are%20the%20inputs%20for%20Actual.%20Chart%20starts%20(F5)%20using%20the%20value%20of%20D6.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20suggest.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi. I have created a dailywise progress report of a project using conditional formatting for estimated and actual progresses. The project is of approx 6 months duration. The project being a lengthy one, it is not possible to print the whole progress in a single page. For that purpose, I have created a dynamic calendar showing 12 months at a time upto the year 2049 in the next worksheet. Now I am unable to use any formula across these two worksheet. My aim was that the calculations in the first sheet (Actual) will be displayed in the calendar of 2nd sheet as colour fill just like the first sheet. The first month and year of the calendar should be automatically selected from the start date of project (from the first sheet), so that the total progress can be be shown in single page itself. Additionally suggest me how can I create a database for such multiple projects?

2 Replies
Highlighted

@lodhnerist , Hi

Sorry if i may not be addressing your specific issue, but i gather that your main intent is to be able to make a Gantt chart for a long project which is easy to print on single page.

Consider making the Plan vs. Actual sheet itself a bit flexible in terms of "Step Days" so that you need not think about the calendar view at all.

I was able to make such a flexible template in which you may print status of a long project on 1 page.

Attaching it for your reference, so that it may give you some hint / clue. If it helps!

 

when step days is 1 :-

 

amit_bhola_0-1588561136759.png

 

and when step days = 7 (week) , the shedule shrinks :-

amit_bhola_1-1588561205474.png

 

Highlighted

Thank you a lot @amit_bhola I think it will work for me for this project. But not getting how  to include stepdays in my Chart. Will you please suggest. I have already included weekend using NETWORKDAYS.INTL.

 

Guide for my chart:

If you go through my chart i think u will get it, where D6 is the only input for the plan (Estimated) and whereas D7, E7, D9, E9, D11, E11, .............. D27, E27 are the inputs for Actual. Chart starts (F5) using the value of D6.  

 

Please suggest.