How to Create a Gantt Chart in Microsoft Excel 2007

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

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

Step

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

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

Step

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

Step

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

Step

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

Step

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

Step

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

Step

Click on your vertical axis.

Step

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

Step

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