Excel 2010 Bible

Part III: Creating Charts and Graphics

476

5. Select the vertical axis and display the Format Axis dialog box.


6. On 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 data series and display the Format Data Series dialog box.


8. On 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 sub-
   stitute for the legend.


10. Apply other formatting and labels as desired.

FIGURE 19.38

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 possible. The key is get-

ting your data set up properly.

Figure 19.39 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.

On the CD
A workbook with this example is available on the companion CD-ROM. The filename is gantt chart.xlsx.