Combine Clustered Column and Stacked Column

  • Thread starter Thread starter Mike Thurgood
  • Start date Start date
M

Mike Thurgood

Is there any way to combine clustered column and stacked
column on the same chart. For each month in the year I
have three bars I wish to show side by side, and within
each bar I would like to have two divisions that are
stacked. For example, suppose I asked three questions of
an audience each month, with possible answers (Yes, No,
Maybe). Now I want to plot the percentage of Yeses and
Nos for each question for each month.

Thanks!
 
Mike -

Through careful arrangement of the data in your worksheet, you can make
a stacked column chart that looks like a clustered-stacked column chart.

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.ie/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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top