Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can population pyramid made in excel ?
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can population pyramid made in excel ?
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel only calculates the confidence interval for a population . | Excel Worksheet Functions | |||
Excel only calculates the confidence interval for a population . | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |