The following map is generated from a GIS shape file (.shp) on the locations of human-made reservoirs around the world.
(Source: Global Reservoir and Dam Database)
However, the map for the number of reservoirs by country is shifted, and North America is split into two parts and they are shown on the opposite side of the map, rather than a continuous continent as the map above.
May I ask why the position of the world map is not fixed, and how to fix it if needed?
It's difficult to tell without your workbook. You can try setting the map such that it shows all countries in a single view. Use zoom in/ out or pan option to set it up the way you want.