Forum Discussion
County lines in Excel map charts extending over bodies of water
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.
My county map chart of the state of Virginia in excel is extending the county boundaries over parts of the Chesapeake Bay, which is making it look strange. I want it to exclude the major water bodies so that it looks like a normal map of VA. I have tried putting in Chesapeake Bay as a row in the data with a value of 0, but this does not work.
I'm not familiar with this region geography and don't how it shall be exactly. If build map on text data we have
if use rich data type
Practically we can't mix them. Perhaps to take texts and play more with names where necessary, sometimes that helps. But not always.
Please check in attached.