Create Color Coded Territory Map from Excel Data

Using Territory Mapping Software to Create a Color Coded Map

Get fresh ideas when you turn your Excel spreadsheet into custom territory maps. A color coded map is made up of multi-colored territory boundaries where an individual color represents a geographical boundary or value. A simple example may be when one wants to create a color coded US map with different groups of states colored the same. Looking at this color coded map makes it easier to distinguish the boundaries. Use Mapline’s territory mapping to see available boundaries.

Color Coded Territory Mapping Example

Steps to create custom territory maps with color coding

  1. Log in to your Mapline account.
  2. Open your Map Excel data
  3. Click “Layers” tab
  4. Choose “Territory Overlay”
  5. Select your territory map type.
  6. Name your territory map
  7. When selecting Territory Coloring: Choose “Paste Custom Colors from Excel”
  8. Download the sample territory set by clicking the “Download a Template” link.
  9. Open the template in Excel. You’ll see the territory name in the first column and the color you would like it to appear in the second column. Make any updates you need in the spreadsheet. Delete any rows of territories you don’t want to appear on your map.
  10. Copy and paste the updated spreadsheet into Mapline. Be sure to include the column headers (Territory and Color)
  11. Click “Continue”

Mapline offers a wide range of territory boundaries which can be added to your color coded map. Check out Mapline’s Available Territories to see what is offered as well as step-by-step instructions on how you can add them to your map or build heat maps with territory colors.

Compare plans and pricing to get started now.