SOLVED

geographical chart (map) in excel not showing up

%3CLINGO-SUB%20id%3D%22lingo-sub-1750793%22%20slang%3D%22en-US%22%3Egeograhical%20chart%20(map)%20in%20excel%20not%20showing%20up%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1750793%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20Excel%20365%20and%26nbsp%3Bgeograhical%20chart%2F%20map%20is%20not%20showing%20up%20right.%3C%2FP%3E%3CP%3EI%20inserted%20in%20Excel%20some%20names%20of%20Dutch%20municipalities%20and%20figures%20regarding%20these%20municipalities%26nbsp%3B%20(inhabitants).%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20get%26nbsp%3Bgeograhical%20chart%20of%20The%20Netherlands%2C%20but%20world%20map%20is%20shown%2C%20without%20colors.%3C%2FP%3E%3CP%3EPrior%20a%20map%20of%20he%20Netherlands%20only%20(not%20world%20map)%20was%20shown%20in%20Excel.%20Why%20not%20now%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1750793%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1752663%22%20slang%3D%22de-DE%22%3ESubject%3A%20geographical%20chart%20(map)%20in%20excel%20not%20showing%20up%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1752663%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F822334%22%20target%3D%22_blank%22%3E%40Niels_83%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EAs%20far%20as%20I%20know%2C%20here%20is%20some%20information%20that%20might%20help%20you.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CH1%20id%3D%22toc-hId-556885180%22%20id%3D%22toc-hId-556885175%22%20id%3D%22toc-hId-556885175%22%20id%3D%22toc-hId-556885175%22%3E%3CFONT%20size%3D%223%22%3EGet%20geographic%20location%20data%3C%2FFONT%3E%3C%2FH1%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fget-geographic-location-data-287b4cf2-3d7d-4bc1-b412-3d00f45dbbd6%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fget-geographic-location-data-287b4cf2-3d7d-4bc1-b412-3d00f45dbbd6%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CH1%20id%3D%22toc-hId--1250569283%22%20id%3D%22toc-hId--1250569288%22%20id%3D%22toc-hId--1250569288%22%20id%3D%22toc-hId--1250569288%22%3E%3CFONT%20size%3D%223%22%3ECreate%20a%20Map%20chart%20in%20Excel%3C%2FFONT%3E%3C%2FH1%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fcreate-a-map-chart-in-excel-f2cfed55-d622-42cd-8ec9-ec8a358b593b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%20size%3D%223%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fcreate-a-map-chart-in-excel-f2cfed55-d622-42cd-8ec9-ec8a358b593b%3C%2FFONT%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F5%2F3%2FC%2F53C9D26C-B87D-45BE-A76C-FFCF78703940%2FMap%20Chart%20samples.xlsx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Edownload%20a%20workbook%20with%20several%20map%20chart%20examples%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help%20you.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ENikolino%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22alt-edited%22%3EI%20know%20that%20I%20know%20nothing%20(Socrates)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1752826%22%20slang%3D%22en-US%22%3EBetreff%3A%20geographical%20chart%20(map)%20in%20excel%20not%20showing%20up%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1752826%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20added%20column%20with%20country%20name%20and%20now%20Excel%20show%20up%20the%20right%20map-focus.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I'm using Excel 365 and geographical chart/ map is not showing up right.

I inserted in Excel some names of Dutch municipalities and figures regarding these municipalities  (inhabitants). 

I want to get geographical chart of The Netherlands, but world map is shown, without colors.

Prior a map of he Netherlands only (not world map) was shown in Excel. Why not now?

3 Replies
Highlighted

@Niels_83 

As far as I know, here is some information that might help you.

Get geographic location data

https://support.microsoft.com/en-us/office/get-geographic-location-data-287b4cf2-3d7d-4bc1-b412-3d00...

Create a Map chart in Excel

https://support.microsoft.com/en-gb/office/create-a-map-chart-in-excel-f2cfed55-d622-42cd-8ec9-ec8a3...

 

download a workbook with several map chart examples

 

I would be happy to know if I could help you.

Nikolino
I know that I know nothing (Socrates)
 
Highlighted

@Nikolino 

I added column with country name and now Excel show up the right map-focus.

Highlighted
Best Response confirmed by Niels_83 (New Contributor)
Solution

@Niels_83 Just add a column indicating that you are looking for "Netherlands". See an example attached. Sometimes you need to put everything in a structured table with clear headers, but not always. Sometimes data typing as Geography helps, but not always. You have to experiment and find what works best for you. The Bing mapping info doesn't always return perfect results for all parts of the world.