How to create Bubble Chart with 4 dimensions

I'm having a ton of trouble trying to create a bubble chart that has 5 columns of data:
1) Name of Country (text)
2) Size of Country (x-axis, numeric)
3) Wealth of Country (y-axis, numeric)
4) Population of Country (determines bubble size, numeric)
5) Continent (determines color of each bubble, text) - all countries from a single continent would be the same color bubble

I've attached a sample with fake data and need a simple solution as I'll have about 30 rows (countries) on the bubble chart. As you can see on the chart, all of the bubbles are the same color and I don't know how to get each continent its own color. Also, I'd like to have the label for each bubble be the name of the country if possible.

Any help would be greatly appreciated, thanks!!
Bubble Chart Sample.xlsx

Thanks so much Andy! That is exactly what I wanted.

I'm a relative newbie to Excel so forgive me if this question doesn't make sense: if I have let's say 50 rows of data provided to me in the original layout, would I use a Macro or Pivot table to convert the data into the new proper layout? Or would I do that manually via copy/paste?

Hi Andy, I have a similar issue around getting the bubble chart to display different colours based on the value of a column (Urgency).
I also have 4 dimensions.

Thanks, you are a genius.

Hi Andy,
thanks again.
does the same concept work for a pie chart (doughnut)
where the colour (1 = Red, 2 = Orange, 3 = Green)as attempted in the worksheet below, changes based on values in column c10:c19?

What do you think...?
see attached sheet