stacked bar chart
 

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

stacked bar chart
 

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

stacked bar chart
 

Thank you very much

"Bernard Liengme" wrote:

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