Multiple Data Series on Same Chart- Stacked Bars

[blevinm]

I would like to create time series stacked bar chart that is grouped by time period for multiple data series. For example: Gender By Country Over Time


The first set of grouped stacked bars would be for 1900 e.g. and may include USA, Germany, China, U.K. with one bar for each country split by gender (52%/48% Female / Male for example)

The second group would be for 1950 and would include the same countries with 1950 gender splits etc...

In the end I would have ONE CHART to communicate the changing gender split over time by country. My data table is currently like:

Columnns USA Germany China UK
Rows
Male Time Period 1 % % % %
Female Time Period 1 % % % %
Male Time Period 2 % % % %
Female Time Period 2 % % % %
....
....


Can this be done in excel??????

HELP!

 

[shades]

Perhaps what Andy has done?

http://andypope.info/charts/stackside.htm

 

[blevinm]

Thanks a lot...This is just what I needed and works well!