How to Make a Gantt Chart in Excel
A Gantt chart is a style of bar chart that illustrates a project's scope. The different bars demonstrate elements of the project, such as the date work began or the amount of work performed as of the current date. Although Microsoft Excel has comprehensive chart-making capabilities, it does not offer a Gantt chart among its standard chart types. With a little tweaking, however, making a Gantt chart in Excel is possible.
Open a new Excel worksheet. For the purposes of this article, enter "Task" in cell A1, "Start Date" in cell B1 and "Length" in cell C1. Type in a few lines of chart data under the appropriate headings. The first column names the tasks, the second column provides a start date, and the third column lists the number of days each task is expected to take.
Select the data table by clicking the first cell and dragging across all the cells you typed data into. Go to the Insert tab and select "Bar" from the Chart panel. Click on "Stacked Bar" under the 2D heading as the chart subtype.
Click on "Select Data" in the Design tab under Chart Tools; the Select Data Source window will open. Remove any entries listed under Legend Entries (Series) by selecting them and clicking "Remove."
Click on "Add" to bring up the Edit Series dialog box. Type "Start Dates" in the Series name field. Delete any values in the Series values field. Click inside the field, then drag your mouse from the first data cell to the last data cell in the Start Dates column; you will see the data range appear in the field. Click on "OK" to return to the Select Data Source window.
Repeat Step 4 to add a new data series. Name it "Length" and select the data in the Length column. Return to the Select Data Source window.
Click on "Edit" under Horizontal (Category) Axis Labels and drag your mouse from the first data cell to the last data cell in the Tasks column (not including the heading). Click on "OK" to return to the Select Data Source window, and "OK" again to return to the worksheet.
Double-click on the colored area in the left side of any of the bars. The Format Data Point box will open. Click on "Fill" and change it to "No Fill." Click on "Border Color" and change it to "No Line." Click "Close" to apply the changes. The first color in the bars will be gone.
Double-click the category axis, which is the area where the task names are listed. The Format Axis dialog box will open. Under Axis Options, click the "Categories in Reverse Order" check box. The chart order will be flip-flopped.
Double-click the value axis, which is the white area where the start dates are shown. The "Format Axis" dialog will open. Under Alignment, change the Custom Angle to 45 degrees. Click "OK" to apply these changes.
Click on the chart legend and press the "Delete" key to remove it.
Tips & Warnings
- If you want the Gantt chart on its own worksheet, right-click it and click on "Location." You can select to show it as an object in another sheet, or as a new sheet.