Microsoft Office Tutorials and References
In Depth Information
Figure 17-8: A comparative histogram.
Here's how to create the chart:
1. Enter the data in A1:C8, as shown in Figure 17-8.
Notice that the values for females are entered as negative values, which is very important.
2. Select A1:C8 and create a bar chart. Use the subtype labeled Clustered Bar.
3. Select the horizontal axis and display the Format Axis task pane.
4. Expand the Number section and specify the following custom number format:
0%;0%;0%
This custom format eliminates the negative signs in the percentages.
5. Select the vertical axis and display the Format Axis task pane.
6. In the Axis Options section, 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 task pane.
8. In the Series Options section, 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.
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 prop-
erly.
Figure 17-9 shows a Gantt chart that depicts the schedule for a project, which is in the range A2:C13. The hori-
zontal 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 at this book's website. The filename is gantt
chart.xlsx.
Search JabSto ::




Custom Search