population age distribution

[Stefan Gildemeister]

I am looking for a way of using Excel to create population
trees. These are common ways to show population
distributions by age and gender. They are essentially bar
charts, with age groups on the vertical axis, with one set
of bars for male and one for female.

Thanks for any thoughts.
S.G.

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.worksheet.functions
with an email copy to Stefan Gildemeister.
Please use the newsgroup for further discussion.]

Convert the numbers for one gender to negative numbers. Now, plot the
data for the two genders as two separate series in the same chart. The
gender with negative numbers will be to the left of the y-axis, the
other to the right. Format to suit, especially the Overlap value
(double-click any plotted series, then select the Options tab in the
resulting dialog box).

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions