Share this Post
In this blog, will show you how to create a Gantt Chart using Excel. Excel doesn’t actually have a default Gantt Chart; therefore, we will modify a bar chart to turn it into a Gantt Chart.
First, we need to enter project information such as Project name, Duration, Start date and Finish date. See the image below and enter your data exactly as shown in the image.
Enter the tasks and duration details as shown in the following image.
Start building the Gantt chart in the right side of the sheet as shown below with appropriate if and and formula into it.
The top row has the dates until it covers both start and finish dates and below rows should be formulated in order to display the timeline of the project with appropriate formula.
So, in the end, you will be with your own project Gantt chart customized accordingly shown below. Kindly comment below for a copy of the free template.