 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / September 20063-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! 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 > 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 [quoted text clipped - 4 lines] > > Any help appreciated!  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info in microsoft.public.excel.charting, >> 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??? >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. [quoted text clipped - 6 lines] >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. SignatureDel Cotter NB Personal replies to this post will send email to del@branta.demon.co.uk, which goes to a spam folder-- please send your email to del3 instead. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.