combine stacked and cluster bar?

[viveleroi0]

I have values that I want to see stacked and clustered. For example,
want values 6 and 10 stacked on one line for June for agent A, the
values 1 of 2 on the second line for agent A, Then the same type o
value structure for agent B.

But excel has value 6 and 10 stcked in with 1 and 2 on the same lin
for agent A.

How do I seperate them

 

[Debra Dalgleish]

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