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

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

"prashant279" <(E-Mail Removed)> wrote in message
news:BF2AE914-5151-433D-805C-(E-Mail Removed)...
> 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 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