hvplot display multilayer classification axis labels

I am looking for a best solution to hvplot the multilayer data. Sorted by Name-Type-Size QTY is the value

I used Excel to make an example, but I'm not sure how to achieve the same goal with Python. I tried use

df.hvplot.bar(
x = 'Name',
y = 'Qty',
by = ['Type', 'Size'] # This is not what I think it can work,the issue is x axis includs a lot of empty Size.
)

Then I use scatter

a.hvplot.scatter(x='Size',
                 y='Qty',
                 by=['Name','Type'],
                  rot=90,
                 alpha=0.5,
                 width=2500,
                 height=400,
                 yformatter = '%0f'
)

It can show the data, but still not very convenient to see.

hvplot.bar(x='Name', y='Qty', by=['Type', 'Size'], rot=90,yformatter = '%0f')

I also tried this one. However, the Size are in question marks and not sure why.

[Size are in question marks][1] [1]: https://i.stack.imgur.com/5mW0I.png

[Data structure][2] [2]: https://i.stack.imgur.com/CQMEd.png

[example using excel][3] [3]: https://i.stack.imgur.com/hv9cU.png

Here is the markdown showing the example data: