Multi-level bar chart: is it possible? how?

[s0050506]

Hello,

I need to plot the following dataset as depicted:
cat1 cat2 A [$] B [$]
1 US 100 80
1 CA 50 40
1 MX 30 20
2 US 120 100
2 CA 35 30
2 MX 40 15
3 US 90 85
3 CA 35 35
3 MX 20 15

Mcapocc.jpg

Is this possible with Excel?
Thank you a lot, Regards Sander

[Andy Pope]

You need to change your data layout, see attached

[s0050506]

Thank you a lot!