Is there a way to put UK post codes in Excel to show a map?

[devil84]

As per title, if i had UK Post Codes in Excel, is it possible to convert this into a map?

[ORoos]

Hi there,

You could use an add-in: Bing Maps (Insert, My Add-ins, search for Bing Maps.
Data stored in a table will be displays. You can have multiple columns and show as Pie charts, or just the one column as a dot/circle.
You could use dynamic cell references for the source data table to show only cities selected by the user (postcode selected).
Issue I noticed, if you select only one location, the map will zoom in to a local level. Work around, have London and Glasgow allways show...

[devil84]

thanks - i have given this a go but which columsn do i drop the post code in. i can't seem to set the target cells

[ORoos]

You need to have the location in the first column, then the post code in the second column.