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