Microsoft Office Tutorials and References
In Depth Information
Creating a population pyramid chart
If you would like to use this technique for an XY chart, you need to adjust the
formulas so that they return #NA instead of an empty string (which is
interpreted as 0). For example:
=IF(B2<=\$C\$1,B2,NA())
Creating a column chart from the data in columns C:F produces a chart with four
data series, and the chart will contain gaps for the blank cells. To eliminate the
gaps, adjust the gap width and overlap. The chart shown has a gap width of 0 and
an overlap of 90.
You can adjust the values in row 1 to create different numeric ranges for the colors.
And, of course, you can add more series to display more than four conditional colors.
Creating a population pyramid chart
A population pyramid chart, sometimes known as a comparative histogram,
compares two groups using horizontal bars. Figure 8-26 shows an example, which
depicts the age distribution, by sex, of the United States. Although this type of chart
is often used with population data, it can be used in a variety of other situations.
Figure 8-26: Producing this population pyramid chart requires a few tricks.
Excel does not provide this type of chart, but you can convert a standard bar
chart using the following steps:
1. Create a stacked-bar chart with two series, using column A for the
category labels, and columns C and E for the data. Note that the percentages
for Males are calculated as negative numbers.
Search JabSto ::

Custom Search