3-tier stacked bar chart
 

Hello - I work for a police department and need to create a stacked bar
chart for homicide victims and suspects by race and gender. The chart
would be separated into victims on the left and suspects on the right.
Within each, there would 3 bars: Black, White, Asian. Within each of
those three bars is male/female. Does anyone know how to enter that
data into an excel spreadsheet???

Any help appreciated!

3-tier stacked bar chart
 

Hi,

Try this data in range A1:D7. Create a stacked column plotting Series in
Rows. You will then need to format the 6 series as appropriate.

Victim Suspect
Black Male 1 1
Female 1 1
White Male 1 1
Female 1 1
Asian Male 1 1
Female 1 1

Cheers
Andy

wrote:
Hello - I work for a police department and need to create a stacked bar
chart for homicide victims and suspects by race and gender. The chart
would be separated into victims on the left and suspects on the right.
Within each, there would 3 bars: Black, White, Asian. Within each of
those three bars is male/female. Does anyone know how to enter that
data into an excel spreadsheet???

Any help appreciated!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

3-tier stacked bar chart
 

in microsoft.public.excel.charting,
wrote:
Hello - I work for a police department and need to create a stacked bar
chart for homicide victims and suspects by race and gender. The chart
would be separated into victims on the left and suspects on the right.
Within each, there would 3 bars: Black, White, Asian. Within each of
those three bars is male/female. Does anyone know how to enter that
data into an excel spreadsheet???

On Tue, 26 Sep 2006, Andy Pope said:
Try this data in range A1:D7. Create a stacked column plotting Series
in Rows. You will then need to format the 6 series as appropriate.

Victim Suspect
Black Male 1 1
Female 1 1
White Male 1 1
Female 1 1
Asian Male 1 1
Female 1 1

Laurie, I wish I knew what it was you were interested in showing:
different graph types work best for different purposes.

When you've followed Andy's advice, try changing the chart type from
Stacked Column to Line. The result will be a graph of a kind sometimes
misnamed "Bumps chart", and it might show what you are trying to show
more effectively.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.