UK Psotcode Map in Excel

[DanD]

I'm trying to create a very simple postcode area map, (AB,DG,G) in excel and then colour the areas based on data in a simple table. The work involved doesn't seem great but what I'm struggling with is finding a map of the UK which I can import into excel and then have each part recognized as a different object, because I think this is probably the easiest way of doing this.

Anyone got any suggestions or an alternative way?

Thanks

Dan

 

[Trevor G]

Which version of Excel are you using, as in the earlier versions you could use an Excel Map feature then that would work for you as you can link the table data to the map.

Take a look at this link it might help !

http://support.microsoft.com/kb/213882

 

[DanD]

I'm currently using Excel 2000, I looked at the link but there was no option to insert a microsoft map.. :S

 

[Trevor G]

Check your add ins and also the Insert Menu your looking for Data Map.

This is a feature that comes with MS Office 2000.

Failing that search the net for inserting data map in Excel 2000.

 

[Norie]

Dan

What have you tried so far?

I think if I wanted this type of functionality the first port of call would be a search to see if someone's already done it.

Maybe even the Royal Mail themselves.

 

[DanD]

Seems we've been upgraded to 2003 and I didn't notice

I've been using google so far in vein to try to see if there is a map already drawn with the areas as individual blocks but haven't found any yet, or any other solution.

Failing this I might just have try and find someone to draw it out!

Cheers

Dan

 

[Trevor G]

Try searching based on Nories idea about the Post Office Maps

http://www.google.co.uk/search?sour...oyal+maps+of+the+uk+by+postcode+used+in+excel

I cam up with this map, it is in PDF but see if it helps

http://www.list-logic.co.uk/free_downloads

 

[Norie]

Dan

There are loads of maps with the main UK postcode areas on them on Google or whatever.

Are you actually looking for something where each postcode area is a separate object?

 

[daverunt]

Another Option:
Microsoft MapPoint can be used with Office programs however it's £300.
But there is a 60 day trial download.

Seems to offer souped up functinality that was in Excel2000.
I have no idea how much work is involved but it might be worth a look.

http://www.microsoft.com/mappoint/en-us/mappointeu.aspx

 

[Norie]

Trevor

That's not a Google search, that's asking Google a question.

Actually, that might be where I'm going wrong - I never seem to be able to find stuff.