Forum Discussion
County lines in Excel map charts extending over bodies of water
Hello,
I'm trying to create a county map of the state of Michigan using Excel's map charts. However, when I do that, the county lines appear to extend over Lake Michigan, making the map look odd. Any way to prevent this? Screenshot attached.
Hi Adam - i have no answer, but Map Charts sometimes has strange behaviour. See for example this topic https://techcommunity.microsoft.com/t5/Charts-and-Visualizing-Data/Map-Chart-Regions-not-displaying-properly/m-p/38243#M18
On the one hand they use bing maps engine with Here maps in the background, on the other hand both Here and Bing maps in some cases show different results compare to Maps Charts. Perhaps different versions/databases or like. I'll be happy if someone from MS team explains this.
Hi Adam and Sergei, did you ever figure out how to fix this problem? I'm having the same issue with a county heat map in VA.
That's only to play with names, formats, etc. If you share what exactly doesn't work we may try to check.
