How to create Gantt Chart using Excel (Free Excel Template)

Follow these Steps

Step No. 1

Create a table containing your activity name, start date, duration, and finish date.

Step No. 2

From the Excel bar choose “Insert”, then “Bar” then choose a Stacked Bar.

Step No. 3

Right-click in the chart area and choose “Select data”.

Step No. 4

From the “Select Data” window, click “Add”.

Step No. 5

Add the start date values into the series values.

Step No. 6

Add a new value same as we did in step no. 4 for the duration.

RECOMMENDED COURSE

Data Management and Reporting

Data Management is the key success of construction projects reporting. This self-study course will teach you using a step by step case…

• 1,680 students
• WhatsApp support group
• Certificate

View course

Step No. 7

Edit the horizontal axis values.

Step No. 8

Add the activity names in the horizontal axis values.

Step No. 9

After adding all the data as per step no. 5,6,7 and 8 just click “OK”.

Step No. 10

Right-click on the blue bar and choose “Format Data Series”.

Step No. 11

From the “Fill Menu”, choose “No Fill”.

Step no. 12

Click on the axis include the activity name and choose the format axis.

Step No. 13

From “Axis Options”, check “Categories in reserve order”.

Step No. 14

Now you have a Gantt chart matching your data in step no. 1, whenever you change any date or duration, the bar chart will be changed automatically.

Download the Gantt Chart Excel Template

Gantt Chart Excel Template 14.67 KB 4211 downloads

This File is included in the following course(s)

Basic Planning Course

Download the Resources of this Article

How to create Gantt Chart using Excel (Article) 632.84 KB 851 downloads

This File is included in the following course(s)

Basic Planning Course

If you’re interested in more Excel tools, check our 3 week Lookahead Template.

---

Keep in Touch

Join our Email Newsletters and receive FREE weekly useful content!

Your Name

Email

---

Related posts:

Understanding Merge Hotspot, Diverge Hotspot, and Logic Hotspot in Project Scheduling How does the planning department balance the management triangle How to calculate working days using excel with sample How to connect Primavera P6 to Power BI (Full Guide) Cost Management for Engineers-Cost Terms