Forum Discussion
Excel > Insert > Maps > World - New Zealand Not Showing
- Dec 24, 2021
Map itself is generated on Bing Map service, it's not within Excel. If you have Map Chart functionality and online connection, result will be the same for any Excel with above.
At the same time Map Chart is quite sensitive to column names and how your data is organized. If you open attached file does it work?
- SergeiBaklanDec 24, 2021Diamond Contributor
Map itself is generated on Bing Map service, it's not within Excel. If you have Map Chart functionality and online connection, result will be the same for any Excel with above.
At the same time Map Chart is quite sensitive to column names and how your data is organized. If you open attached file does it work?
- PeterMoss99Dec 24, 2021Copper Contributor
SergeiBaklan Okay - I've found what I think is the problem. I loaded your xlsx file on my laptop and, yes, NZ was shown. Then I typed Brazil over New Zealand ... and NZ disappeared from the chart! I took my data set (which doesn't contain NZ and which doesn't show NZ on the chart) and added New Zealand with a random value ... and NZ appeared on the chart! So, it appears as if the 'world' map only shows New Zealand if NZ appears in the data set.
- FahimMcGApr 12, 2023Copper ContributorHi everyone, I understand this is an old discussion. I hope that someone follows this context and would be able to help. I am looking to use Wellington Regions map in Excel. I tested my data in different ways, but the Bing Maps does not recognise the regions. Not sure if that's a problem with New Zealand Map or you may face the same limitation when using Canada or US map. appreciate it if you could provide guidance and assistance. Thanks
- PeterMoss99Dec 24, 2021Copper ContributorYes, it works 100%, but I'm out at present so viewing on my phone. When I get home I'll try on my Surface Laptop 3. I'm sure you are right - I'll fiddle about and see if I can get NZ to render. Many thanks! 👍 👏🙏