Creating Gantt Chart In Excel For Your Projects

The Gantt chart is a graphical method used for planning and monitoring tasks and activities specified in a project. It is widely used in project management today.

In this article, I have told you with an example how you can create a Gantt chart in Excel.

First of all, the tasks, the people to be assigned, and the start and end dates are determined. A selectable list is then created showing the status of the tasks.

In order to be able to apply conditional formatting in cells, the following formula is written.

=IF(AND(G$4>=$D5;G$4<=$E5);”a”;””)

Then the following formulas are written to the cells from conditional formatting.

=AND($B5=”Completed”;G5=”a”)

=AND($B5=”Continues”;G5=”a”)

=AND($B5=”Not Started”;G5=”a”)

Note: Don’t forget to choose the same font and background color in formatting! Because the letters “a” that we write should not appear.

Finally, let’s add a donut chart showing the status of the tasks.

=COUNTIF(Page1!$C$5:$C$14;Page2!B3)

After creating the donut chart, we select the data labels as “percentage”.

Here is your Gantt chart colored by the status of the tasks!

You can also manage your projects better this way.