Have a look at Jon's example:
http://peltiertech.com/Excel/Charts/tornadochart.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"RichHoughton" wrote in message
...
Hi

I'm trying to chart people totals by age band against sex (male or
female).
I have a stacked bar chart that aligns to the left but i would like to
shift
the y-axis centrally and then chart right if male or left if female
(doesn't
really matter which way). I've tried shifting the axis but figures to the
left go into negative.

data eg. SEX 0 to 4 5 to 14 15 to 44 45 to 54
MALE 119 411 1326 549
FEMALE 120 423 1297 547

The goal is a tree shaped graph, narrow at base getting larger in the
middle
before shrinking near the top. Can it be done?

Many thanks
rich