How to Create a Gantt Chart in Microsoft Excel 2007

By Alex Zang

Gantt charts are used to provide a visual representation of the start and end times of various things. Unlike previous versions of Microsoft Excel, Excel 2007 does not contain an option for creating a Gantt chart. If you want to create a Gantt chart, you need to modify a pre-existing bar graph type chart. After you've done this once, you can save your newly created Gantt chart as a template chart, which means you'll be able create a new Gantt chart without going through the same process.

Step 1

Open the spreadsheet you want to create the Gantt chart in.

Step 2

Highlight the data you'll be using for your Gantt chart by clicking on the top-right corner and dragging a box down to the bottom-left corner.

Step 3

Select the "Insert" tab. Click "Bar Graph."

Step 4

Select "Stacked Bar," located underneath the 2-D Bar.

Step 5

Click anywhere in the chart. A new "Chart Tools" dialog box will appear. Click the "Design" tab, and then select "Style 27."

Step 6

Click on the first data series in your chart. Click "Format Selection," found under the "Current Selection" group of the "Format" tab.

Step 7

Click on the "Fill" button, and then click "No Fill." Click "Close."

Step 8

Click on the legend in the chart area, and then press the "Delete" key.

Step 9

Click on your vertical axis.

Step 10

Click "Format Selection," found under the "Format" tab, in the "Current Selection" heading.

Step 11

Select the "Categories in Reverse Order" check box, and then click "Close."