Clustered and stacked

[Juan]

Hi,

I'm trying to create a combined chart (clustered and
stacked)

I have four series three need to be stacked in one column
and the second column needs to be next to it (clustered)

Thanks so much in advance

Juan Pulido
Cvent, Inc.
Finance
(e-mail address removed)

 

[Jon Peltier]

Hi Juan -

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/
_______