In excel, how do you get a stacked bar chart with different variables for each bar?

I need a horizontal bar chart with 3 separate bars. The data for each bar are for different areas which need to be represented proportionally. Here they are, maybe it will be clearer.





Commercial


Global Banks 26


Private Banks 1


Commercial banks 45


Regional Banks 25





Public


Multilateral Banks 2


Bilateral Banks 25


Local Development Banks 19





Microcredit


Microcredit 2





So the 3 bars would be commercial, public, microcredit. The way they are divided needs to be visible.


Thanks|||Put them in a list format, create a pivot table and then create a horizontal stack bar chart





Grouping Banks Number


Commercial Global Banks 26


Commercial Private Banks 1


Commercial Commercial banks 45


Commercial Regional Banks 25


Public Multilateral Banks 2


Public Bilateral Banks 25


Public Local Development Banks 19


Microcredit Microcredit 2