Demographic chart?

[Aggie]

Hi,
I need to create a demographic chart in Excel, but I can't find the proper
chart type. Is there a suitable chart type? I've gone through all options I
can think of for a regular bar chart. (In my world, a demographic chart is a
bar chart with the values pointing in two different directions... Not very
complicated, but Excel doesn't seem to agree with me!) Does anyone know of an
adequate solution?
BR -
Aggie

 

[Andy Pope]

Hi,

They are also known as Tornado charts or population pyramids.

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

Cheers
Andy

 

[Aggie]

Hi Andy,
Many thanks! My graph looks almost exactly like I want it to now! I can't
get the number format right for the custom format - I'd prefer a thousand
seperator where there is none - but I can definitely live with that.
I'm surprised there's no tool in Excel though... Maybe something for the
next version?
BR -
Aggie