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.

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

---

Download the PDF version of this Article to share with your colleague

---

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