Skip to main content
Jacqueline Wade
Environmental engineer
Asked a question 2 years ago

How to prepare a Gantt chart in Excel?

How to prepare a Gantt chart in Excel?

Where am I?

In TheConstructor you can ask and answer questions and share your experience with others!

Gantt chart enable the user(s) or a team to create and share a visual planning regarding a project or event you are managing to your colleagues or management. By doing this, you will increase the chance on finishing the project in a more efficient way, which will increase the companies effectiveness. Therefore, Gantt charts are seen as a very effective project management planning tools, especially when more than 1 person is involved in the success that follows after succeeding of a project. The total of all elementary project components can be called "the work breakdown structure of the project". This is how it looks like in a Gantt chart:

As you can see, the difference between the list of activities, and the Gantt chart that shows the work breakdown structure, are the following advantages:

Simplifying the complexity of a project; Synergy effect among all team members, and making it more effective; Every stakeholder is on the same page; Determining milestones and deliverables according a fixed time schedule; Creating team productivity; Making everything visual and manageable.

Advanced Gantt charts additionally demonstrate the reliance (i.e., priority) connections between deliverables (which shows a liability as well for all team members). Gantt charts can be applied to show current project status by informing the percentage of successful completion of the project, and a vertical "Today" line can be implemented here as well. Gantt charts allow you to schedule activities and resources and are helpful when you are planning and tracking various business processes. For example, you can have a list of activities on the left and a suitable time scale along the top in order to see the following at a glance: List of activities that are needed to be done

Beginning and ending of activity; Time that is available per activity; The liability between 2 ore more activities; The whole project's start and end dates.

For example, here you can see a generic Event Gantt chart, which structures the following activities:

Determine host event Pick a budget Pick a location Pick a date Make a guest list Choose a theme Send out invitations Order equipment Plan the food menu Line up extra hands Execute last minute orders Help with thank you notes Prepare some games Follow up RSVP stragglers Make the goody bags Plan take away gifts Assign photographer Clean up Prepare food Complete groceries Quick cleaning sweep Set up party space Pick up the cake Designate honoree

Raul Jimenez
Senior Project Manager

A Gantt chart helps you schedule your project tasks and then helps you track your progress. The steps for preparing a gantt chart in excel are as follows :- 

1. Create a project table 

2. Make a standard Excel Bar chart based on Start date 

3. Add Duration data to the chart 

4. Add task descriptions to the Gantt chart

 5. Transform the bar graph into the Excel Gantt chart

 6. Improve the design of your Excel Gantt chart and done.

Terry Collins
Sustainability consultant


Following are the steps of preparing a Gantt chart in excel

Create a new table for the project Based on the start date, made a standard excel bar chart Insert duration data in chart Adding a task description in the Gantt chart Then transform a bar graph into an excel chart. Improve your design

You may also download a Gantt chart template from the internet.

Hope you get the answer.

Select the data you want to chart. ... Click Insert > Insert Bar Chart > Stacked Bar chart. Next, we'll format the stacked bar chart to appear like a Gantt chart. ... If you don't need the legend or chart title, click it and press DELETE. Let's also reverse the task order so that it starts with Task1