Forum Discussion

Copper Contributor

May 03, 2020

Gantt Chart

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

Test duration - Comparison.xlsx95 KB

excel

Formulas and Functions

amit_bhola

Iron Contributor

May 04, 2020

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 :-

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

Gantt Chart v3.xlsx163 KB

lodhnerist

Copper Contributor

May 12, 2020

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.