Stacked Charts

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating stacked bar for multiple groups and multiple years 2
Excel Need assistance with modifying a Duplicate declaration. 13
Bar Charts 1
How to Arrange Data for Chart 6
Total of Stacked Column Chart 1
Stacked bar chart with totals - Excel 2003 2
How can I combine a stacked column chart and line chart? 1
Stack Bar Charts 1

Top