Side by Side Stacked Chart

[Nan]

I am trying to create a stacked bar chart that compares 2003 vs 200
data by person. How do I get the 2003 and 2004 stacked columns for eac
person on the X axis next to each other

 

[Andy Pope]

Hi Nan,

A little confused by your question subject and the data described.
There doesn't appear to be another data to required the side by side stack.

So here is how to make a simple stack.
You need to lay your data out in 3 columns.

2003 2004
Person_A 1 2
Person_B 2 3
Person_C 3 4
Person_D 4 5


Hightlight the data and use the chart wizard to create a stacked column
chart.

If you need an introduction to charts take a look at Jon Peltier's.
http://peltiertech.com/Excel/ChartsHowTo/ChartIntro.html


And for side by side stacked chart take a look at these,
(Cribbed from Debra Dalgleish's answer to a previous post.)

If you stagger your data, you can create side-by-side stacked columns.

Bernard Liengme has an example and instructions on his site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

and the following MSKB article has an example:
XL2000: Creating Charts with Multiple Groups of Stacked Bars
http://support.microsoft.com/default.aspx?id=214119


Cheers
Andy