View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
nathanhutto nathanhutto is offline
external usenet poster
 
Posts: 6
Default 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