3-tier stacked bar chart

  • Thread starter Thread starter laurie_woods1
  • Start date Start date
L

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!
 
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
 
in microsoft.public.excel.charting,
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
Click to expand...

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.
 
Back
Top