Hi, can anyone suggest a way of mapping sales people on a UK map using just a list of names and the postal areas they cover (e.g. Adam AB, AL, B, BA). Excel maps and 3d mapping don't recognise the areas and data types thinks they are countries, not UK postal areas. Ideally I want to have a different colour for each person and shade the postal area in a map in their colour. So that you can see which areas they cover.
Name | Postal Area |
Gordon | AB |
Adam | AL |
Adam | B |
David | BA |
Ben | BB |
Ben | BD |
David | BH |
Ben | BL |
Steve | BN |
Steve | BR |
David | BS |
Ben | CA |
Adam | CB |