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