Stacked Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is what I want to accomplish using a stacked chart:

Option A - FY 2003 and Option A - FY 2004 data stacked on top of each other.

In the same chart beside Option A data I would like to see:

Option B - FY 2003 and Option B - FY 2004 data stacked on top of each other.

Is this possible?
Krystina
 
Hi Krystina,

The trick is the layout of your data, here are some examples,

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

Cheers
Andy
 
Back
Top