It is all explained he
http://peltiertech.com/Excel/Charts/tornadochart.html
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme

"Aaron" wrote in message
...
Hello everyone:

I've a problem: I'm drawing a population pyramid bolstered by a
3-dimensional database, with the population as the only figure to display,
and break up by gender, age group, and record year; e.g.

Year Gender Agegroup Population
2000 Male 10-14 200000
1999 Female 5-9 1340000

I've got a total 2 years in year break up, 2 gender types, male & female,
and about 10 age groups;

What I wanna to do is to generate a bar chart, with age break displayed on
the vertical axis, population displayed on the horizontal axis, and break
up
by gender, shown on alternative quadrants of horizontal axis devided by
vertical null point (treat female figure as negative), and stack the year
data on the vertical axis, show an example:

++++++|++++++++ Year 2000,Age group
15-19
*****|****** Year 2005,Age group
15-19
+++++++++|++++++++++ Year 2000,Age group 10-14
*******|******* Year 2005,Age group
10-14
++++++|+++++++ Year 2000,Age group
5-9
*******|********* Year 2005,Age group 5-9
Female _____________|_______________Male

Where * and + represents different years' break, left and right quadrants
represent gender break, and vertical axis represent age break, the length
of
+ and * represent the population figure;

I've been doing this graph using a statistical software and I would like
to
move it into excel file to link the datapoints to other files, enabling
this
chart manipulatable by altering the figures to obtain dynamic effects, how
can this be achieved?

Thanks & appreciates!