100% Stacked Bar Chart, Heights Relative to Additional Values / Series

[netty625]

Greetings,

I'm trying to create a stacked bar chart, but with the length of the bar adjusted relative to a second series on the primary axis. I'm analyzing the occurance of key terms in the meetings of various departments, but I want the length of each department's bar proportional to the length of the meeting. Using the example below, columns B, C, D, and E would be charted in the 100% stacked bar chart, with the length of each bar relative to column F.
[TABLE="width: 680"]
<tbody>[TR]
[TD][/TD]
[TD]Environment[/TD]
[TD]Equity[/TD]
[TD]Economy[/TD]
[TD]Efficiency[/TD]
[TD]Length of Meeting(mins)[/TD]
[/TR]
[TR]
[TD]Department 1[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]55[/TD]
[/TR]
[TR]
[TD]Department 2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]23[/TD]
[/TR]
[TR]
[TD]Department 3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]71[/TD]
[/TR]
</tbody><colgroup><col><col span="5"></colgroup>[/TABLE]


I'm aware that the width of a 100% stacked bar can be changed (a Marimekko chart) and that another bar can be superimposed on top of stacked bars (a bullet graph). A bullet graph (or something like it) may be a better product for me in the end, but I at least want to see how my idea would look. If anyone has any other suggestions (for instance, pie charts of varying sizes), I'd be most appreciative to hear them.

Thanks

 

[netty625]

Apologies, forgot to mention:

I'm using Windows 7 and Excel 2010.