Office Excel 365 - Insert Map - No Southern Ireland?

natheplas

Board Regular
Joined
Aug 28, 2016
Messages
89
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,
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,290
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
Aug 28, 2016
Messages
89
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

Well-known Member
Joined
Mar 31, 2015
Messages
2,290
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
Aug 28, 2016
Messages
89

ADVERTISEMENT

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-known Member
Joined
Mar 31, 2015
Messages
2,290
Office Version
  1. 365
Platform
  1. Windows
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.
 
Last edited:

natheplas

Board Regular
Joined
Aug 28, 2016
Messages
89
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,
 

Watch MrExcel Video

Forum statistics

Threads
1,109,028
Messages
5,526,336
Members
409,696
Latest member
EERS

This Week's Hot Topics

Top