how to create 100% stacked column chart with multiple legends

[MoCuishle]

As the graph demostrated, now I have data of
- 3 brands (A, B, C)
- 2 product types (X, Y)
in 4 Quarters

I want to show the product types mix trend across 3 brands and during the 4 Quarters. the chart should looks like below.

in 100% Stacked column, Axis should be Quarter, Legend is Brand A, B, C and values is the unit of Product(X, Y)

the questions is, how to put multiple legends to show saperately Brand A, B, C?

[lbendlin]

Stacked column charts now support Small Multiples. Add your Quarter value there.