Clustered and stacked

  • Thread starter Thread starter Juan
  • Start date Start date
J

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)
 
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/
_______
 
Back
Top