I have been working with Excel Map Charts for the first time over recent weeks. With a lot of trial and error I have most of the UK counties displaying correctly. I've cracked province column titles on the countries to get my counties located correctly and have broadly found county systems that work.
I am however really struggling with Neath Port Talbot in Wales. If I place this in the map chart alone, it comes up where I think Swansea should be. Swansea is correctly displayed so both are directed to the same county and the one next door, that I think is Neath Port Talbot, has me totally stumped. Help hugely appreciated as it has taken me a long time to get to this point, to have this one Welsh county defeating me. Is there a work around to get the data displaying manually alternatively?