Microsoft Office Tutorials and References
In Depth Information
Creating a Gantt Chart
3. Select the category (vertical) axis, and press Ctrl+1 to display the Format Axis dialog box.
4. In the Format Axis dialog box, click the Axis Options tab and specify Categories in
Reverse Order to display the tasks in order, starting at the top; choose Horizontal Axis
Crosses at Maximum Category to display the dates at the bottom.
5. Select the Start Date data series and display the Format Data Series dialog box.
6. In the Format Data Series dialog box, click the Fill tab and specify No Fill; click the Border
Color tab and specify No Line.
These steps effectively hide the data series.
7. Select the value (horizontal) axis and display the Format Axis dialog box.
8. In the Format Axis dialog box, adjust the Minimum and Maximum settings to
accommodate the dates that you want to display on the axis.
In this example, the minimum is 5/3/2010, and the maximum is 7/21/2010.
9. Specify for the Major Unit option, to display one-week intervals, and use the Number 7
tab to specify a date format for the axis labels.
10. Apply other formatting as desired.
 
Search JabSto ::




Custom Search