How to Create a Gantt Chart Using Excel 2003

1. Type a schedule into four columns in Excel. Type the names of milestones for your project in column 'A,' then type the start dates in column 'B,' then type the duration in days in column 'C' and the project end date in column 'D.'
2. Click the 'Chart Wizard' button, then click the 'Bar Chart' on the left-hand side. Click 'Stacked Bar Chart' as the chart subtype.
3. Click the 'Series' tab.
4. Click 'add' to add a series from your spreadsheet. Type a name for one of the series in the 'Series name' text box -- for example, type 'Start Date.' Type the location for your series into the 'Values' box -- for example, if your start dates are in cells 'B1' to 'B10,' type 'B1:B10.'
5. Repeat Step 4 to add the name and location of the 'Duration' series.
6. Click the 'Category Axis' button and highlight the tasks you listed in column 'A.' This adds labels on the left-hand side of your chart. Click the 'Finish' button.
7. Drag the bottom right corner of the chart until the chart fills the screen.
8. Right-click the 'X' axis on the chart. Click 'Format Axis,' then click '10' for the font size. Click 'OK.'
9. Right-click the 'Y' axis on the chart. Click 'Format Axis,' then click '10' for the font size. Click 'OK.'
10. Right-click the blue bars on the chart, then click 'Format Series.' Click the 'None' radio buttons next to Border and Area. Click 'OK.'
11. Right-click on the 'Y-axis' label, then click 'Format Axis.' Click the 'Scale' tab, then click the 'Categories in Reverse Order' check box. Click 'OK.'