Forum Discussion
Solved
Devon, UK does not show on Excel Maps
i.
I am plotting counties of the UK - specifically the South West of England. This includes Cornwall, Devon, Somerset and Dorset. Excel maps WILL NOT plot Devon, no matter what I call it. I have tried:
Devon
UK, Devon
Devon, UK
Devon, United Kingdom
Devon, GB
Devon, GB, United Kingdom
On Bing maps, Devon comes up absolutely fine. What is the problem please?
Paul, did you try Devonshire?
Hi Paul
I'm trying to do the same thing, could you give me the list of counties you're using (inc. Wales, Scotland and NI?) there is something odd with the way it recognises counties as I've got Devon in my list and it's working fine. I'm having a problem with what on earth (no pun intended) the other options for Essex, Suffolk and Norfolk are!!
thanks
martin
Martin Radford
Here is my list below. I didn't do Northern Ireland but the main missing areas in England are in blue: Sandwell, Walsall, Wolverhampton, City of York and St Helens in England.Province County England Barnsley England Bath and North East Somerset England Bedford England Bedfordshire England Berkshire England Birmingham England Blackburn with Darwen England Blackpool England Bournemouth England Bradford England Brighton and Hove England Bristol England Buckinghamshire England Calderdale England Cambridgeshire England Central Bedfordshire England Cheshire England Cheshire East England Cornwall England County Durham England Coventry England Cumberland England Cumbria England Darlington England Derby England Derbyshire England Devon England Doncaster England Dorset England Dudley England East Riding of Yorkshire England East Sussex England Essex England Gateshead England Gloucestershire England Greater London England Greater Manchester England Halton England Hampshire England Hartlepool England Herefordshire England Hertfordshire England Humberston England Isle of Wight England Isles of Scilly England Kent England Kingston Upon Hull England Kirklees England Knowsley England Lancashire England Leeds England Leicester England Leicestershire England Lincolnshire England Liverpool England Luton England Medway England Merseyside England Middlesbrough England Milton Keynes England Newcastle-upon-Tyne England Norfolk England North East Lincolnshire England North Lincolnshire England North Somerset England North Tyneside England North Yorkshire England Northamptonshire England Northumberland England Nottingham England Nottinghamshire England Oxfordshire England Peterborough England Plymouth England Portsmouth England Preston England Rotherham England Rutland England Sandwell England Sefton England Selby England Sheffield England Shropshire England Slough England Solihull England Somerset England South Gloucestershire England South Tyneside England South Yorkshire England Southampton England Southend-On-Sea England St Helens England Staffordshire England Stockton-on-Tees England Stoke-on-Trent England Suffolk England Sunderland England Surrey England Swindon England Telford and Wrekin England The City of York England Thurrock England Torbay England Tyne & Wear England Wakefield England Walsall England Warrington England Warwickshire England West Midlands England West Sussex England West Yorkshire England Wiltshire England Wolverhampton England Worcestershire England Worthing Scotland Aberdeen City Scotland Aberdeenshire Scotland Alloa Scotland Angus Scotland Argyllshire Scotland Ayrshire Scotland Banffshire Scotland Berwickshire Scotland Borders Scotland Caithness Scotland Clackmannanshire Scotland Dumfries & Galloway Scotland Dunbartonshire Scotland Dundee Scotland East Ayrshire Scotland East Dunbartonshire Scotland East Lothian Scotland East Renfrewshire Scotland Edinburgh Scotland Falkirk Scotland Fife Scotland Glasgow Scotland Highland Scotland Inverclyde Scotland Kincardineshire Scotland Lanarkshire Scotland Midlothian Scotland Moray Scotland North Ayrshire Scotland North Lanarkshire Scotland Orkney Scotland Perth Scotland Perth & Kinross Scotland Renfrewshire Scotland Shetland Scotland South Ayrshire Scotland South Lanarkshire Scotland Stirlingshire Scotland West Dunbartonshire Scotland West Lothian Scotland Western Isles Wales Blaenau Gwent Wales Bridgend Wales Caerphilly Wales Cardiff Wales Carmarthenshire Wales Ceredigion Wales Conwy Wales Denbighshire Wales Flintshire Wales Gwynedd Wales Isle of Anglesey Wales Merthyr Tydfil Wales Monmouthshire Wales Neath Port Talbot Wales Newport Wales Pembrokeshire Wales Powys Wales Rhondda Cynon Taff Wales Swansea Wales Torfaen Wales Vale of Glamorgan Wales Wrexham Hi Martin,
It very depends not only on counties names, but also on how you name your column. If, for example, England, NI, etc you call Countries you have one picture. If States - another.
In attached map counties you mentioned are shown. However, not sure all counties are recognized.
Hi Sergie,
Hope you don't mind. I've attached an update to your UK Maps file correcting the data for Scotland. There are currently 32 council areas (counties) in Scotland which I have listed. There are still some errors which I think are bugs in the map chart application (see Below).
Errors for Scotland
Renfrewshire, West Dunbartonshire and Midlothian are correct counties but do not show on the map.
Using the names Hebrides and Ayrshire show the areas on the map but these areas are incorrectly named.
Hebrides should be Na h-Eileanan an Iar (Gaelic for Western Isles)
Ayrshire should be South Ayrshire.Hope this helps others in the community.
Paul, did you try Devonshire?
THANK YOU!
I was too close to the elephant there...
