UK Data Map

N

nekthen

New Member
Joined
Mar 8, 2024
Messages
8
Office Version
  1. 365
Platform
  1. Windows
I have a selection of English Counties

1726826753373.png


The grey areas are not mapped even though the data is there and is verified as geographic data for example
Cumbria
38,722​

Is not mapped even though it is part of the series1. It seems that there is a disconnect between the official counties list and the map. It seems incredible that microsoft have not addressed this. Does anyone have a work around?
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
I tried the disambiguation technique mention in MS forum
1726828970195.png


It made no difference. The data was sent to Bing and Cumbria is still missing!
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
Map sales area using UK postal area
Replies
2
Views
194
Trevor G
Trevor G
S
  • Question Question
Finding Distance between 2 UK postcodes in Excel
Replies
2
Views
2K
sk211
S
R
  • Question Question
Excel 3d Maps - Unable to add more than 1 Field to Location
Replies
2
Views
752
Rogojosh
R
A
  • Question Question
Xlookup, Vlookup and/or VBA for finding, matching and inputting data to separate sheet
Replies
0
Views
860
AlfredDB
A
R
  • Question Question
VBA to add to data model when creating Power Query tables`
Replies
3
Views
708
Raddle
R

Forum statistics

Threads
1,225,768
Messages
6,186,924
Members
453,387
Latest member
uzairkhan

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top