Side by Side Bar chart with stacked bar

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Is there any way to create a side by side bar chart with
one bar being a stacked bar? Here's the data:

Name Q2 Q3wk1 Q3wk2 Q3wk3
Ann 86 9 6 11
Bob 62 0 10 4
Carl 66 0 4 4
Dave 46 2 1 3

So I would want one bar with Q2 data for each person and
then a stacked bar with all three weeks of Q3 data for
each person

Thanks
 
Tom -

Through careful arrangement of the data in your worksheet, you can make
a stacked column chart that looks like a clustered-stacked column chart.
Your data would be staggered, with extra blank rows inserted, like this:

Q2 Q3wk1 Q3wk2 Q3wk3

Ann 86
9 6 11

Bob 62
0 10 4

Carl 66
0 4 4

Dave 46
2 1 3

There is a tutorial showing this technique on Bernard Liengme's site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

which is based on the example on Stephen Bullen's web site:
http://www.bmsltd.co.uk/Excel/Default.htm
Go to Charting Examples, and download FunChart4.xls

The following MSKB article has an example:
XL2000: Creating Charts with Multiple Groups of Stacked Bars
http://support.microsoft.com/default.aspx?scid=kb;en-ca;214119

- Jon
 
Back
Top