Lesson#39: Cool tricks to make automatically updating Gantt chart

Lesson#39: Cool tricks to make automatically updating Gantt chart
Hi, friend today I will show you how to make an automatically updating Gantt chart without using an Excel chart. Here I am making a program schedule with this criteria Activity no, Description, Start Date, End Date, and Days (shown in the picture below). Where color chart will be automatically updated depending upon the value of the start date and end date.

The purpose is to update the color chart automatically when I will change the value of the start date or end date. This color will show the duration of work graphically within the area below dates written horizontally on the left side.

So I have put a simple formula within the area below dates written horizontally on the left side.
=IF(AND(F$1>$C2-1,F$1<$D2+1),”>”,””) which will generate the character “>” along the row within the area below dates written horizontally on the left side and only below those cells which come from the start date to end date.

The formula is to be dragged throughout the area where the graphical chart is to be generated.

automatically updating gantt chart

How this formula is working shown in the picture above. 90% of my work is completed in this step. The remaining work is to make conditional formatting within the area where I want to show the graphical chart.

automatically updating gantt chart

I have put a condition which will color those cells where it contains the text “>” and I have put the fill color and text color the same so the text won’t be visible only the color chart will be visible.

automatically updating gantt chart

That’s pretty cool. I have given a download link for the file below. You can modify and make your chart by using this formula.

See also  Lesson#7: How to make nested IF in Excel?

Download

Related Video Tutorials:

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Leave a Reply

Your email address will not be published. Required fields are marked *

*