Map Chart (Excel 2016)

Hi,

 

I'm trying to plot a geographical heatmap of the UK by using the Map chart powered by bing on Excel 2016. It works fine when I use the 4 counties below:

 

United Kingdom Northumberland 25%
United Kingdom Durham 25%
United Kingdom Tyne and Wear 25%
United Kingdom North Yorkshire 25%

It also works fine if I change Durham by another county (e.g. Norfolk). But it’s when I add Norfolk on top of the 4 counties that the map stops working (chart area is white with a yellow error message on the top asking to check data).

United Kingdom Northumberland 25%
United Kingdom Norfolk 10%
United Kingdom Durham 15%
United Kingdom Tyne and Wear 25%
United Kingdom North Yorkshire 25% 

It seems like the map only works with a maximum of 4 counties.


Many thanks for your help,

Tristan

Hi Tristan,

 

You can always use Map Chart to show categories and compare values across geographical regions. We suggest that you try to check this article to know more about Map Chart in Excel 2016.

 

Get back to us if you need further help.

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi John,

Thanks for your message.

I've already seen that video a few days ago and it did not help solving my issue. I do know how to use the map chart but as I said there is a bug occurring each time I add more than 4 regions (counties in my example).

Have you tried to plot the UK map chart with the data I provided (5 counties)?

United Kingdom Northumberland 25%
United Kingdom Norfolk 10%
United Kingdom Durham 15%
United Kingdom Tyne and Wear 25%
United Kingdom North Yorkshire 25% 


Many thanks for your help,

Tristan

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

We nee to know more about this issue, we suggest that you try to run the Office Configuration Tool. This tool will provide you detailed report of your installed Office programs. To know more about the tool, click on this link.

Let us know if you need additional assistance.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

That's a disambiguation error, meaning that Bing is seeing more than one Norfolk and can't resolve the location. Can you add another layer of location detail?
Every once in a while there's a sudden gust of gravity...

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Thanks for your message Smitty,

I don't think there is anything to do with Norfolk specifically. I've plotted the chart again with more regions and it worked. However, the chart is erratic! If I just amend the legend's name, the whole UK map becomes blue. Do you have any idea why the map powered by Bing is not robust? Are you experiencing the same issues?

Country Region Weight
United Kingdom Durham 33%
United Kingdom Essex 15%
United Kingdom Glasgow 2%
United Kingdom Norfolk 11%
United Kingdom Northumberland 4%
United Kingdom Tyne and Wear 26%
United Kingdom Yorkshire 8%

Many thanks,

Tristan

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I think you're right. The reason why the chart isn't working is that some of the regions are similar in different countries (Norfok and Durham are in the USA as well as in the UK). Do you know if there is another way to input the data (e.g. "Durham, UK" in the same cell instead of having different columns)? I've tried to add postcodes but it didn't work.

Otherwise, could I use the geographical coordinates?

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

We suggest that you try to repair your Office. Since your Excel is not working properly, restarting it sometimes fix the issue. To know more on how to repair your Office, please click on this link.

Let us know if you need further help.

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi, I've been having similar problems.

For most counties I have to put "xxxxx, United Kingdom" in the cell for the 3D map to recognise it properly.

London Boroughs just do not work - I had do do that manually. No variation of name, London, England, UK etc would work.

I cannot find anyway for it to recognise Cardiff, Caerphilly, Swansea, Edinburgh and the plot for Powys misses a lot of the eastern side - there's a gap between Powys and Herefordshire which should not be there.

This is a great tool, and if the territories can be corrected it will become really useful.

Does anyone have a workaround for these missing counties?

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

 
 

Question Info


Last updated June 6, 2020 Views 6,909 Applies to: