How to create a bubble chart with 3 categories and by year

Hi,
I've been having trouble creating a bubble chart that I need, other than doing it manually with different tools.

I have a data set over a number of years by:
country (A thru O in this example);
volume;
market share.

I'm trying to recreate the visual that I mocked up in this worksheet (attached). I added 'number of units' to try and spread the bubbles in each year 'column' although I can't find a way to make that work.

I also want to add the country label to each bubble - things such as the vertical dotted lines I can add on post production.

Any ideas?

Thanks in advance - this is my first post!

Regards,