Solved: Showing Male and Female Ages on the same chart

[psionic]

It's me again it's been awhile.

I would like to ask if anyone has an idea (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

The idea is that I am analysing the age groups with a database. I have seen medical, civic and statistical charts showing a breakdown of ages showing the gender side by side. 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.

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]

Andy Pope showed an interesting Pyrmaid chart here http://www.ozgrid.com/forum/showthread.php?t=42124

[david000]

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]

And here are some more pages on tornado / pyramid charts

http://peltiertech.com/Excel/Charts/tornadochart.html
http://tushar-mehta.com/excel/softwa...ado/index.html