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.