Can a map chart have bubbles?

verytiredgirl
verytiredgirl Member
in Charting

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?

Tagged:

Answers

  • DavidChurchman
    DavidChurchman Coach

    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

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Categories