software

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 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

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

peltiertech.com/Excel/Charts/tornadochart.html

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

quot;prashant279quot; gt; wrote in message
...
gt; TO ANY MESSENGER OF GOD !!!
gt;
gt; I'm trying to make a population Pyramid but unable to do so. Can any one
gt; help me out .
gt;
gt; To give you an e.g of what i need to do is a Population Pyramid Chart.
gt; Anyone can go on www.google.com and search for POPULATION PYRAMID in
gt; Images
gt; section and you will see A POPULATION PYRAMID of various countries.
gt;
gt; I want to know how can we replicate the same in Excel without inputting
gt; negative values on the X axis.
gt;
gt; Looking to have 0 in center...Males Bar on LHS and Females bar on RHS of
gt; the
gt; centre point of chart. And both values need to be positive .
gt;
gt; Plz help or e-mail me on with ur repllies. It
gt; would
gt; be great . Thanks a Million . My Job is on the Line if id ont get this
gt; done .
gt;
gt;
gt; Plz do reply .
gt;
gt; All the best
gt;
gt; Prashant