I have a list of company and their relative headquarters location in the following form: region/subregion/country - see "ContryTable" tab in the attached spreadsheet.
With "region" I mean for instance Asia, Europe, Africa; while for subregion I mean for instance "Eastern Asia".
From that list I have created a pivot table which gives me how many companies there are for each subregion - see "MapPivot" in the attached spreadsheet.
Finally, I have created a map chart from that pivot table and a filter to show region by region - see "Dashboard" in the attached spreadsheet.
When I click on "South America" or "North America" or “Africa" in the filter, the map shows me properly those regions by zooming in. If I click on "Europe", "Middle East" or "Oceania" the map does not zoom in, this is because the mapping between the regions and the country is wrong according to Bing.
I am looking for someone able to fix this problem, in particular:
1. The map should zoom in properly everywhere on each region
2. Currently the map work with the subregions, I want to make it work with the region.
The budget for this gig is 10USD
9 freelanceria on tarjonnut keskimäärin 50$ tähän työhön
Hi, I have understand the project requirement & interested to make for this project. I will do it within 90 min. Please send a message so we can discuss more & start the project. Thanks.