E
edward
How do I draw a gender-disaggregated age pyramid using MS Excel
L
Leo Heuser
edward said:
Edward
Maybe Insert > Diagram
is, what you need.
A
Andy Pope
Hi,
Tornado chart maybe?
http://peltiertech.com/Excel/Charts/tornadochart.html
http://tushar-mehta.com/excel/software/tornado/index.html
http://www.andypope.info/ngs/ng3.htm
Cheers
Andy
Tornado chart maybe?
http://peltiertech.com/Excel/Charts/tornadochart.html
http://tushar-mehta.com/excel/software/tornado/index.html
http://www.andypope.info/ngs/ng3.htm
Cheers
Andy
T
Tushar Mehta
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
G
Gaj Vidmar
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
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