combining chart types
 

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

combining chart types
 

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/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"nathanhutto" wrote in message
...
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