Microsoft Office Tutorials and References
In Depth Information
Figure 17-32 shows the age distribution for 1950 and 2013.
Figure 17-32: Population by age group, for two years.
The years are entered in cells C2 and G2. The years can be entered manually, selected from a drop-down list
(using data validation), or specified by using a scroll bar linked to a cell. Formulas below the chart retrieve data
from a table that has population statistics (and projections) from 1950 through 2100.