Can a map chart have bubbles?

verytiredgirl

My dataset doesn't have longitude or latitude, just the Province Name and Province Code, but I would like to have a world map showing sales as the size of the bubble of each Province. How would I achieve this?

DavidChurchman

Find a table with the lat/long of the provinces and join it to your table of values so you can use the lat/long map. There aren't that many provinces, so if you don't want to bother with a join, it wouldn't be that hard to do it in a BeastMode for lat and Beastmode for long. Something like:

— Latitute

Case

when Province = 'Saskatchewan' then 55

when Province = 'Prince Edward Island' then 46.25

…

END

I haven't checked these, but this came up in a quick Google search:

https://www.latlong.net/category/provinces-40-60.html