Microsoft Office Tutorials and References
In Depth Information
Creating Gantt charts
2. Select the value axis (on the bottom) and access the Format Axis dialog
box. Select the Number tab and apply the following custom number format:
0%;0%;0%
This custom format eliminates the negative signs in the percentages.
3. Select the category axis (in the middle of the chart) and access the Format
Axis dialog box. Click the Patterns tab and remove all tick marks. Set the
Tick Mark Labels option to Low. This keeps the axis in the center of the
chart, but displays the axis labels at the left side.
4. Select either of the data series and then access the Format Data Series
dialog box. Click the Options tab and set the Gap width to 0.
Creating Gantt charts
A Gantt chart is a horizontal bar chart often used in project management
applications. Although Excel doesn’t support Gantt charts per se, you can fairly easily
create a simple Gantt chart. The key is getting your data set up properly.
Figure 8-27 shows a Gantt chart set up to depict the schedule for a project, in
range A1:C13. The horizontal axis represents the total time span of the project, and
each bar represents a project task. The viewer can quickly see the duration for each
task and identify overlapping tasks.
Figure 8-27: You can create a simple Gantt chart from a bar chart.
Search JabSto ::




Custom Search