3-tier stacked bar chart

[laurie_woods1]

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]

Hi,

Try this data in range A17. 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

 

[Del Cotter]

in microsoft.public.excel.charting,

Try this data in range A17. 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.