Hi Dominik,

Yes, I'm seeing that, too. Apparently the most recent update to Google Sheets has changed how the marker-style maps work.

There seems to be an answer to why the old lat/lon map no longer works. The GeoChart documentation (https://developers.google.com/chart/interactive/docs/gallery/geochart) says:

"Marker location [Required]
The first column is a specific string address (for example, "1600 Pennsylvania Ave").
OR
The first two columns are numeric, where the first column is the latitude, and the second column is the longitude."

So now lat and lon have to be two separate columns. I tried that with the sample data, and while it seems to produce a map, there is an error when you go to edit chart, and I'm not sure how to fix it.

In the other tab in my Google Sheet, it looks like Cities in EU still works, but I have no idea why that would work and the comparable World Capitals map doesn't. Sometimes it takes a little time for Google to do the search to find all of the location names, so you could try with just a couple of locations at first to see if it's working, but maybe something else has changed.

The document above does also make a note about what works best for markers:

"Note: Although we recommend ISO 3166 codes to be used for 'regions' mode, 'markers' mode works best with longer names for regions (like Germany, Panama, etc). This is because geocharts, when in 'markers' mode, uses Google Maps for geocoding the locations (converting a string location to a latitude and longitude). This may result in ambiguous locations not getting geocoded as you might expect; such as 'DE' standing for Germany or Delaware, or 'PA' standing for Panama or Pennsylvania."

I do have longer names for the cities in both the EU and World Capitals sheets, but for some reason it's only working for the EU map. Sorry I haven't been able to figure out why!