combining chart types

[nathanhutto]

Hi all,

I am trying to create a chart showing pre-kindergarten student enrollment in
1975 & 2000 for about 15 countries. Countries will be on Y-axis. I want to
create a bar chart that will be divided in half, with 1975 on the left side
and 2000 on the right side, each side showing 0-100%. I know how to do this
with a 100% stacked bar.

What I'm having problems with is this....for 1975, I have just one
percentage (enrollment) for each country. For 2000 I have data for 3 & 4 year
olds. What I'd like to do with make the left side (1975) a regular bar chart
and the right side a clustered bar chart, all the while keeping the whole
chart a 100% stacked bar.

Sorry if that's confusing. Thanks for the help

 

[Jon Peltier]

Use one of these approaches, and use them to guide your arrangement of data
rows and blank rows to get what you need to show:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

- Jon