Drawing an Age Pyramid

  • Thread starter Thread starter Guest
  • Start date Start date
How do I draw a gender-disaggregated age pyramid using MS Excel
Click to expand...
Convert the values for one of the genders (male or female doesn't matter) to
negative numbers. Now, plot this converted data and the original data for
the other gender in a Bar (horizontal bars) sub type 'Stacked Bar'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
If you search using Google on "population pyramid excel", you'll find more
than plenty of sites with detailed instructions.
The first hit on the list is the site I recommend when teaching Excel
courses to official statistics people:

http://www-agecon.ag.ohio-state.edu/class/aede597.01/gonzalez/pyramid/

An Excel file with instructions and a slightly more "dressed up" example I
just found is at

http://www.healthinformation.on.ca/poppypramid97 with projection line.XLT

A rather carefully crafted dynamic version (Eurostat projection 2004-2051)
with slider control (based on examples by Prof. Erich Neuwirth from Vienna)
is at

http://www.mf.uni-lj.si/ibmi-englis...atProjekcijaPrebivalstvaSlovenije20042051.xls

(though it's in Slovenian, which is the second smallest official EU language
and one of the world's most "difficult" languages, at least judged by
entropy and similar complexity measures, everything should be
understandable; the "workings" are in hidden sheets).

Best regards,

Gaj Vidmar

(indulging in newsgroups on sick leave after surgery, so taking some
symbolic rest from work by not including my employer in the signature :)
 
Back
Top