I need to combine graphs in Excel

[jebry]

Hi!

I need to combine two types of graphs in Excel. I want to use a stacked column to show the relationship between three related numbers, but I also want to group the columns by threes so I can relate different organizational units.

Specifically, I want to follow an enrollment cohort for a specific department and show what percentage remains enrolled and what percentage completes their degree and what percentage leaves. This will be the stacked column.

Then I want to compare these cohorts with the same year's cohort for the College that the department is in and to the University as a whole.

So, is there any way to combine these graphs, or to group the columns of a stacked column graph. I am also open to completely different solutions if you know of any!

Thanks!


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[SkipVought]

Jeff,

It is possible to plot data using TWO Chart Types in the same Chart. Unfortunately, Stacked Column & Clustered Column cannot be plotted in the same chart.

You can, however, plot two separate charts that are positioned one on top of the other. The on on top would have no axes values, but you'ld have to programatically match the value axis MIN and MAX values so that the scale would be the same. Also the chart on top would have the following:
[tt]
ChartArea
Fill - None
Line - None
PlotArea
Fill - None
Line - None
[/tt]


Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}