If you want to show your office locations/Delivery center locations world wide on a map in excel.
- Take a blank world map and paste it on excel worksheet
- Add x and y scatter chart on the map
- Fix the x and y axis of the chart . Do not keep them manually
- Start adding the x and y coordinates manually.Like see range("Q2:S2")
- Create the database of x and y coordinates for each country Like" Lookup worksheet" World Map automated.
- Write a macro to add series automatically to the map on click
- Please download "steps to create a world map on excel.xlsx" to understand it better
- Goto "Source Data" worksheet
- Clear all the data of Col A to D of this worksheet from row 2 on wards.
- Add the "Type" and "Country" manually in Col A and B
- Keep Column C and D blank. It will be automatically filled by macro
- Goto "Map" sheet and click on create map button.