UK Map Chart

[ellenlayzell]

Hello,

I am trying to make a UK map chart to show how many participants there are in a survey per region. I have just about managed to work out how to add a UK map, however Excel does not recognise the regions or my data. I have watched endless Youtube videos and read other forum threads and I have no idea why it is not working.

Any advice?

[#2]

@ellenlayzell 

That's better to discuss with the sample file. Map Chart very depends on column names, exact place names, granularity, do you use structured table or plain text, with data types or not.

Related discussion are here from time to time, first I found

Mapping data about East Yorkshire in Excel - Microsoft Tech Community

Devon, UK does not show on Excel Maps - Microsoft Tech Community