Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
Combining Chart types | Charts and Charting in Excel | |||
Combining 2 different types of bar graph | Charts and Charting in Excel | |||
Create a combo chart with two of the same chart types | Charts and Charting in Excel | |||
Combining Font Types | Excel Discussion (Misc queries) |