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

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" <(E-Mail Removed)> wrote in message
news:6C944E81-9D9F-41E1-BF00-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:6C944E81-9D9F-41E1-BF00-(E-Mail Removed)...
> > 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
>
>
>