How to make a Gantt chart in Excel

• Input your data in the following format

• Leaving the upper left cell blank sends the right signal to Excel in terms of assumptions it will make about the kind of chart we want.

• Select the data range containing our first three columns (omit the ""stop date"" column) from the heading row to the bottom of our data.

• Click on the chart wizard and choose stacked bar chart."

• Double click the category axis (the task names along the left edge of the chart).
• On the Scale tab, check the Categories in Reverse Order and the Value (Y) Axis Crosses at Maximum Category options, and type a 1 in the Number of Categories Between Tick Marks box.
• Single click on the legend and delete it.

• Double click the Value axis (the times across the bottom), and the Scale tab.
• Select a better start date (you can type it in mm/dd/yy format).
• Change the major spacing to 7 or 14 days.
• Click on the number tab and select a better format for the date (e.g., dd-mmm) as here.

• Double click on the left part of the bars to select the data series for ""start"" and set its border and fill to none.
• Finish formatting as you like