Share via

Excel mapping

Anonymous
2022-02-26T10:48:58+00:00

Hi there

I'm having real trouble mapping a single UK location in Excel. I'm using Office 365 latest version and am trying to develop a heat map for all UK districts using Excel maps in conjunction with text data in three columns in this format;

Country State District Pereg
United Kingdom England Avon 30
United Kingdom England Barnsley 31
United Kingdom England Bath and North East Somerset 32
United Kingdom England Bedford 33
United Kingdom England Berkshire 34
United Kingdom England Birmingham 35

I cannot map St Helens, Merseyside and have tried every possible combination. Does anyone have a template of UK county data which maps all UK counties (or point me to one) please? This is driving me mad!

Thanks in advance

Steve Watson

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

6 answers

Sort by: Most helpful
  1. Anonymous
    2022-02-26T17:08:49+00:00

    I just had another brainstorm.

    .

    Since you are down to one missing code, email someone in the geographic location.

    Try to contact someone who would be using Excel to do mapping. Teacher, College or University student, someone at a Town or City hall who has to do mapping etc.

    .

    PS: when you complete the "set", please share it with us. Thanks.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2022-02-26T16:52:00+00:00

    Great idea! Thanks

    Steve

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2022-02-26T16:27:29+00:00

    suggestion, try googling for covid maps in excel. They would have to cover all of the regions ...

    .

    Good luck.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2022-02-26T15:58:07+00:00

    Hi there

    Thanks for this - very quick and helpful.

    One would have thought that a 'standard' database template would be available for each country which maps completely for all administrative regions. I've had to fill my UK map on a trial-and-error basis and it's taken me two weeks to get to the point where I am short of one datapoint out of 223 (!). I've googled this to hell and back and queried this forum as a last resort.

    One might have expected that someone somewhere has a full working template but I can't find anything sadly.

    Once again thanks for your help with this - I'll keep trying.

    All best

    Steve

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2022-02-26T15:30:04+00:00

    Funny thing, other people have complained about similar issues, specifically about mapping England. They too couldn't find all of the required codes to fill their map. England/UK what ever you call it is so ancient is has a very confusing to non-natives mix of location names and alternative spellings.

    .

    MS has not replied with a complete list.

    .

    Your best bet is to google you butt off to find an existing example map of England with the appropriate location names/codes/abbreviations. If you find any, even in the wrong location subdivisions, please post them back here so we can share them with others in the future.

    .

    Submit a feedback to MS complaining about this deficiency. The map template should ship with complete list of the names required for the various subdivisions.

    .

    You could also try posting your question on Facebook and/or Twitter

    .

    Feedback Hub

    The “Answers” forum / community is “staffed” mostly by users like yourself, unpaid volunteers. This forum is intended more for “How to do something in application A” type questions. We sometimes can provide work-arounds for problems, but we can’t do anything about underlying problem. If the forum can’t solve your question you need to talk directly to MS, you need to submit a “Feedback” to MS.
    .

    For a couple of years now MS has had a "feedback" process that allows users submit bug reports / problems, suggestions and new feature requests directly to MS developers and managers. You can submit feedbacks from within many MS apps, or you can use the Win10 “Feedback Hub” app. This article describes the different ways you can submit Feedback to MS:
    https://answers.microsoft.com/en-us/msoffice/forum/all/microsoft-feedback-process/6f850368-8c86-481d-a207-d95b265c4be4
    .

    There is also a new web based “Feedback Portal” in development. It is still labelled “Preview”. It provides functionality similar to the feedback hub. Access to feedbacks submitted in 34 categories.
    https://feedbackportal.microsoft.com/feedback/

    .

    As users we are unpaid quality control testers, we identify bugs, they pick which feedbacks they will work on, and when they will release them, for testing by Insiders and to general public.
    .

    But don't "expect" anything like feedback about your feedback back from MS.
    .

    MS will make fixes and changes on their own schedule.
    .

    They will not provide much, if any, advance notice of what they are working on and/or when it will be released.
    .

    Hint : get a “share” link to your feedback (may take a couple of minutes to process the initial submission of the feedback) and post the link back to this question. That way if someone finds this question they will be able to link directly to your feedback so they can vote for it and add their comments. The more feedback on a subject, the more likely it is to be acted on.

    i.e.

    "Feedback" suggesting that they create a "Support / Support" category in the feedback app to collect complaints about poor service in MS Support: https://aka.ms/AAdyeq0
    .

    PS: also be publicly vocal about your complaints.  Post on social media
    https://cloudblogs.microsoft.com/industry-blog/microsoft-in-business/media-comm/2017/04/18/microsoft-uses-social-media-create-customer-experience/
    .

    Facebook

    https://www.facebook.com/pg/Microsoft365/posts/ Follow Microsoft 365 on Social Media: Post Complaints on Twitter https://docs.microsoft.com/en-us/microsoft-365/community/microsoft-365-on-social-media Go to above page for the following list

    General

    If you're having general issues with Microsoft 365, be sure to check the Microsoft 365 Service health status page and/or follow @MSFT365Status for information about any known service incidents.

    You can reach out to Microsoft Customer Service & Support directly on twitter: @MicrosoftHelps.

    Hashtag Official Account
    #Microsoft365 @Microsoft365
    #MicrosoftDocs @docsmsft
    #MicrosoftSearch @MicrosoftSearch
    #MicrosoftLearn @MicrosoftLearn
    #M365CommDocs @M365CommDocs
    #MSUSPartner @MSUSPartner

    Messaging and Communications

    Seeking help on Microsoft Teams? Include #MSTeamsHelp in your tweet.

    Hashtag Official Account
    #MicrosoftTeams @MicrosoftTeams
    #Microsoft365Groups
    #AzureAD @AzureAD
    #MSOutlook @Outlook
    #Yammer @Yammer
    #AdaptiveCards

    Content Management

    Seeking help on SharePoint and Content Management? Include #SPhelp in your tweet.

    Hashtag Official Account
    #SharePoint, #SharePointSpaces @SharePoint
    #ProjectCortex, #Syntex @SharePoint
    #MicrosoftLists, #ProjectNucleus @SharePoint
    #OneDrive @OneDrive
    #MicrosoftStream @MicrosoftStream
    #MSFTViva
    Office Suite
    Hashtag Official Account
    @Office
    #OneNote @msonenote
    #Excel @msexcel
    #MSWord
    #PowerPoint @PowerPoint
    Power Platform
    Hashtag Official Account
    #PowerPlatform @MSPowerPlat
    #PowerApps @MSPowerApps
    #PowerAutomate @MSPowerAutomate
    #PowerBI, #DAX, #PowerQuery @MSPowerBI
    #PowerVirtualAgents @MSPowerVirtual
    #Dataverse
    #AIBuilder
    Other Apps
    Hashtag Official Account
    #MSVisio @msvisio
    #MSProject @project
    #MSWhiteboard
    #MSForms
    @SkypeBusiness
    @MS_StaffHub
    @sway
    @MicrosoftToDo
    #ProjectMoca
    Development
    Hashtag Official Account
    #SPFx @Microsoft365Dev
    #MicrosoftGraph @Microsoft365Dev
    #PnPPowerShell @PnpPowershell
    #PnPjs @m365pnpjs
    #M365PnP @m365pnp
    #CLIMicrosoft365 @climicrosoft365

    .

    Was this answer helpful?

    0 comments No comments