Create Gannt Chart In Excel
The Video above explains how to make a Gannt Chart in MS Excel. The Text below is from a Microsoft Excel Support Blog
The following procedure will help you create a Gantt chart with results that are similar to those shown in our example Gantt chart graphic. For this chart, we used the example worksheet data below. You can also use your own data, as long as you use the same column headers and worksheet structure.
Excel 2016 and 2013
TIP: If your project has a more complex schedule and you want to capture dependencies, you might want to create the Gantt chart in Microsoft Project instead.
To create a Gantt chart like the one in our example that shows task progress in days, follow these steps:
- Create the following data in an Excel spreadsheet.If your data’s in a continuous range of cells, select any cell in that range to include all the data in that range.
If your data isn’t in a continuous range, select the cells while holding down the Ctrl key.
TIP: If you don’t want to include specific rows or columns of data you can hide them on the worksheet. Find out more about selecting data for your chart.
- In Excel 2013, click Insert > Insert Bar Chart > Stacked Bar.–OR–
In Excel 2016, click Insert > Insert Column or Bar Chart > Stacked Bar.
- Next, we’ll format the stacked bar chart to apper like a Gantt chart. In the chart, right-click the first data series
- (the Startpart of the bar in blue) and click Fill > No Fill.
- If you don’t need the legend or chart title, click on it and press DELETE.
- Let’s also reverse the task order so that it starts with Task1. Right-click the vertical axis (Tasks) and click Format Axis >Categories in reverse order box.