If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
suggestion for excel tool option | David Coleman | General Discussions | 7 | November 10th, 2005 03:33 AM |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
Slow response to every change made in Excel | Gig | General Discussion | 1 | April 23rd, 2005 11:20 AM |
I am using Excel and have made an error. | Millie Irene | Charts and Charting | 1 | February 16th, 2005 04:57 PM |
F-Test without population | Ion Chalmers Freeman | Worksheet Functions | 6 | January 28th, 2004 07:51 PM |