Map with bubbles - Location names instead of Lat/Long?

I have a SharePoint list that people choose one or more states from a list for each item (what is the project location, may have multiple locations). What I’d like is a map with bubbles for the count of projects in that state. But the dashboard maker requires Lat/Longs… If I did a lookup or calculated column in the list, it wouldn’t calculate each of the locations into Lat/Longs, so what can I do?

I’m not a programmer, so please be gentle. :slight_smile:

Unfortunately, Lat/Long are both required. Easiest way to do what you want would be to add Lat/Long manually to the list of States. Then, in your list where you have a lookup for the states, go to list settings, select your lookup column and select additional fields of Lat/Long:

Then go to Dashboard Designer and build the Map.