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

--
Message posted from http://www.ExcelForum.com

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/E...ps/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


viveleroi0 < wrote:
> I have values that I want to see stacked and clustered. For example, I
> want values 6 and 10 stacked on one line for June for agent A, then
> values 1 of 2 on the second line for agent A, Then the same type of
> value structure for agent B.
>
> But excel has value 6 and 10 stcked in with 1 and 2 on the same line
> for agent A.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html