Office Excel 365 - Insert Map - No Southern Ireland?

[natheplas]

Hi All,

I have a list of values and locations. I then go to insert, then map graph.

A map appears and plots well, but the southern Ireland bit of the map is missing.

I've tried changing it to towns, cities etc, but southern ireland is blanked out.

Does anyone know why or how I could get around this please?

Thank you,

 

[DRSteele]

What do you mean by "Southern Ireland"? Is the map of Eire there but Limerick, Cork and Killarney are missing? Or do you mean that the country Ireland is missing?

 

[natheplas]

Hi DRSteele,

Yeah so Wales, down to cornwall on England side is all there.

Then on the left we only have northern ireland, but southern ireland is no where to be seen, but there is data for southern ireland.

Do you have an email or someway I can show you please via sending an image, might help.

Thank you,

 

[DRSteele]

That's strange...my map shows all of the emerald isle.

It's verbotten to pass email adresses in this forum. But you can load a photo to these posts by putting the image on another website and then linking it. Lots of memebers here use something called Imgur, or some such thing.

 

[natheplas]

Sorry! I didn't realise. Thanks for letting me know about Imgur - Please look at the link https://imgur.com/a/mTQ4oAQ

Can you see how Southern Ireland is missing, but northern Ireland is there??

Thanks,

 

[DRSteele]

Well, it seems that only UK land is being shown, including the UK-occupied part of the island Ireland, called Northern Ireland. There is no such thing as 'Southern Ireland' - the area you reference is Ireland (or, Republic of Ireland).

Did you start with data for the UK? Try adding data for Cork and Limerick and see if it cooperates.

 

[natheplas]

Okay, yeah that makes sense in what you are saying. Are you able to return 1 map from data in excel displaying just UK and Ireland?

I currently use postcodes + values. What would be best to use to return UK + Ireland on a map please?

Thanks,