Microsoft Office Tutorials and References
In Depth Information
6. In the Axis Options tab, set all tick marks to None and set the Axis Labels option to Low.
This setting keeps the vertical axis in the center of the chart but displays the axis labels at
the left side.
7. Select either of the data series and display the Format Data Series dialog box.
8. In the Series Options tab, set the Series Overlap to 100% and the Gap Width to 0%.
9. Delete the legend and add two text boxes to the chart (Females and Males) to substitute
for the legend.
10. Apply other formatting and labels as desired.
Figure 17-7: A comparative histogram.
Creating a Gantt chart
A Gantt chart is a horizontal bar chart often used in project management applications. Although
Excel doesn’t support Gantt charts per se, creating a simple Gantt chart is fairly easy. The key is
getting your data set up properly.
Figure 17-8 shows a Gantt chart that depicts the schedule for a project, which is in the range
A2: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.
A workbook with this example is available on the companion CD-ROM. The filename is
gantt chart.xlsx .