PDA

View Full Version : Solved: Showing Male and Female Ages on the same chart



psionic
04-27-2008, 07:31 PM
It's me again :hi: it's been awhile.

I would like to ask if anyone has an idea :help (in VBA code or otherwise) or links for research (to follow up on) or any idea how to show two bar charts side-by-side as one whole graph. A sort of custom chart as the standard charts by Excel is lacking :doh:

The idea is that I am analysing the age groups with a database.:whistle: I have seen medical, civic and statistical charts showing a breakdown of ages showing the gender side by side.:think: You wonder what software they used to make these charts anyway...

I calculated the age by their year deriving their age and charted using a group feature.:thumb

Looks like this

Males Females
xxxxxxxx 0-10 xxxxx
xxxxxx11-20 xxx
xxxxx21-30 xxxxx
etc.

Any assistance would be a real bonus!

Thanks,
Psionic.

Bob Phillips
04-28-2008, 12:29 AM
Andy Pope showed an interesting Pyrmaid chart here http://www.ozgrid.com/forum/showthread.php?t=42124

david000
04-28-2008, 12:35 AM
It looks similar to your typed picture but...well you'll see. (attached)

I using Excel 2007 and I can't use any colors right now. I can't figure out the compatibility issue just yet, so this is UGLY!

Andy Pope
04-28-2008, 12:39 AM
And here are some more pages on tornado / pyramid charts

http://peltiertech.com/Excel/Charts/tornadochart.html
http://tushar-mehta.com/excel/software/tornado/index.html