How can population pyramid made in excel ?

[Guest]

TO ANY MESSENGER OF GOD !!!

I'm trying to make a population Pyramid but unable to do so. Can any one
help me out .

To give you an e.g of what i need to do is a Population Pyramid Chart.
Anyone can go on www.google.com and search for POPULATION PYRAMID in Images
section and you will see A POPULATION PYRAMID of various countries.

I want to know how can we replicate the same in Excel without inputting
negative values on the X axis.

Looking to have 0 in center...Males Bar on LHS and Females bar on RHS of the
centre point of chart. And both values need to be positive .

Plz help or e-mail me on (e-mail address removed) with ur repllies. It would
be great . Thanks a Million . My Job is on the Line if id ont get this done .


Plz do reply .

All the best

Prashant

 

[Jon Peltier]

That's also called a tornado chart. You do need negative numbers, but a
custom number format hides the sign.

http://peltiertech.com/Excel/Charts/tornadochart.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______