Clustered Stacked Chart

[Dokat]

I am trying to build a stack chart with below data. When i tried to build the chart it doesmt stacked the columns (x1,x2,x3),(y1,y2,y3),(D1,D2) and compare to thsi vs. last year. Can anyone help?

[TABLE="width: 606"]
<colgroup><col width="202" span="3" style="width:152pt"> </colgroup><tbody>[TR]
[TD="class: xl68, width: 202"] Subbrand[/TD]
[TD="class: xl71, width: 202"]Last Year[/TD]
[TD="class: xl71, width: 202"]This Yea[/TD]
[/TR]
[TR]
[TD="class: xl74"]X1[/TD]
[TD="class: xl75"]$0.0[/TD]
[TD="class: xl75"]$4.1[/TD]
[/TR]
[TR]
[TD="class: xl70"]X2[/TD]
[TD="class: xl73"]$4.8[/TD]
[TD="class: xl73"]$4.1[/TD]
[/TR]
[TR]
[TD="class: xl74"]X3[/TD]
[TD="class: xl75"]$7.4[/TD]
[TD="class: xl75"]$7.8[/TD]
[/TR]
[TR]
[TD="class: xl70"]Y1[/TD]
[TD="class: xl73"]$0.0[/TD]
[TD="class: xl73"]$2.3[/TD]
[/TR]
[TR]
[TD="class: xl74"]Y2[/TD]
[TD="class: xl75"]$0.4[/TD]
[TD="class: xl75"]$0.6[/TD]
[/TR]
[TR]
[TD="class: xl70"]Y3[/TD]
[TD="class: xl73"]$2.5[/TD]
[TD="class: xl73"]$2.5[/TD]
[/TR]
[TR]
[TD="class: xl74"]D1[/TD]
[TD="class: xl72"]$0.0[/TD]
[TD="class: xl72"]$2.1[/TD]
[/TR]
[TR]
[TD="class: xl70"]D2[/TD]
[TD="class: xl73"]$1.9[/TD]
[TD="class: xl73"]$1.3[/TD]
[/TR]
</tbody>[/TABLE]

 

[sheetspread]

This is what I got, what results were you expecting:

 

[Dokat]

Thank you for your response. However I am trying to stack all x,y,z values for this year and compare to last year side by side.

This is what I got, what results were you expecting:

 

[sheetspread]

That's possible if you rearrange the data:

 

[Dokat]

Thank you so much! This is what I was looking for.

That's possible if you rearrange the data:

 

[BeckyW]

Thank you, very helpful. Becky