How to Color Shade a Simple List of ZIP Codes on a Map

Many first-time users of Map Business Online business mapping software begin their search for a mapping tool with a list of ZIP codes. Businesses of all types find themselves in possession of a list of ZIP codes with a desire to:

  • Visualize or color-shade ZIP codes to reflect sales or business activity on a map
  • Define sales territories or areas of interest on a ZIP code map
  • Visualize ZIP codes on a map with business data appended to a ZIP code label

Map Business Online enables all of the above capability and so much more. But let’s keep this focused on the very basic need to visualize and color shade a list of ZIP codes.

While Map Business Online users may easily select one or more ZIP codes and create color shaded areas manually simply by using their mouse cursor to click on a map-based ZIP code, the fastest way to create a color shaded ZIP code area is by importing a spreadsheet of ZIPs. Clicking and holding the shift key gets you there, but it takes a while if you’re talking more than ten ZIPs per area of interest.

Build a simple spreadsheet that lists your ZIP codes. Simply label a column in your spreadsheet as ZIP codes. Add any ZIP codes of interest to that column, and import that data into Map Business Online.

Additional columns are not necessary but could be helpful to your project. You could, for instance, have columns for Territory Name, Sales History, Equipment, or Sales Rep.  That’s up to you and your business requirements. The data will import exactly the same regardless of the number of columns you include.

Import your ZIP code list using the Plot Data button on the Master Toolbar. Read more about data plotting.  To semi-automate data updates to your data imports read this.

Color Shade Your Imported ZIP Codes

As you finish importing your data and the points show up on the map, a dialogue pops up offering help in color coding your data points on the map. Those ZIP code points you just imported represent the center locations of each ZIP code you’re interested in. Answer Yes only if you want to color code the actual points you just plotted, as opposed to color shading the actual ZIP code areas.

If you want to color shade ZIP code areas, click No. Most often Map Business Online users want to color shade the ZIP areas, not just the ZIP code points.  Now uncheck the imported ZIP code layer box in the Map & Data box.  Your points will disappear. Don’t panic, that’s cool.  Go to the middle of the master Toolbar and click the Three Puzzle Piece button. Select the ZIP code map layer option, choose your imported data, and the column of your data that you would like to use for color shading.

If you want to shade every ZIP code a different color, you can color shade up to one hundred ZIPs. It’s less confusing for the map viewer to choose color shades based on a limited number of color groups, or perhaps just one or two shades. Much depends on the purpose of your map. May we suggest:

  • To display  ZIP code areas with business activity – Use one prominent color
  • To display worst to best activity by ZIP code – Use color gradations
  • To designate X or Y options – Use two colors (adjust as necessary for more options)

When attempting to show just one-color shade try using the Count option in the data drop down. You will notice the minimum number of color groups allowed is two. Choose 2 color groups and set the ranges to 0 to 0 and 1 to 1. Color the group of ZIP codes with no points (0 to 0) to light green. Color the ZIP codes with points (1 to 1) a nice blue (or a color of your choosing.) Click Done and bask in the color shading of your ZIP code list.

You may retire now.  Well, maybe not.

Look at all the fun users have with ZIP codes!

There are several more aspects to the color shading process that you may want to keep in mind:

  • The maximum color range quantity is one hundred (so if you have more than 100 ZIP codes, that’s no good.)
  • You can choose to hide non-impacted ZIP codes or change their default color
  • Unique value and Exclude values options can come in handy occasionally. These help to make larger, more varied datasets, easier to classify.
  • Once you’ve chosen your color shading scheme, complete the operation either by clicking preview or done.
  • Remember, it’s wicked easy to go back and reconfigure the color scheme again. All your settings will be saved.  Experiment to your heart’s content. You can’t break it.

Or Just Create Territories from a ZIP Code List

Another way to create those color shaded ZIP areas is to add a Name column to your simple ZIP code list and import the list using the Create Territories button.  You’d have one column for ZIP codes and another column for a name or list of names.

Instead of using the Plot Data Button move one more button to the right and click Create Territories. This import process is nearly identical to the Plot Data process until it moves to the Create Territory function.  Once in the Create Territory dialogue, you will simply match your ZIP code map layer and the Name columns to the proper Map Business Online input fields. Read about the Create Territories process here.

Don’t be intimidated by the concept of territories. You will not be required to use the territories in a complex way, they can just be shaded ZIP codes if you want to keep it simple.  Just remember there is powerful data analysis capability built into territory management

Leverage Your Imported Data

You may have business lists by address that include ZIP codes.  No need to cull out the columns that are not ZIP codes, just import as described above and set the other columns to None as you process the address dialogue into Map Business Online. Your data will behave just like a ZIP code list.

Once your data is imported into Map Business Online, the application allows the map user access to all imported data from a variety of places. In addition to color shading by ZIP code area or ZIP code point, that data is available for territory management and analysis, data window filtering, and market analysis.  When you’re ready, there’s much more that can be done with Map Business Online.

Win a $20 Gift Card! Refer a business associate to Map Business Online in exchange for a $20 Amazon Gift Card!

Find out why over 25,000 business users log into www.MapBusinessOnline.com for their business mapping software and advanced sales territory mapping solution. The best replacement for Microsoft MapPoint happens to be the most affordable.

Contact: Geoffrey Ives geoffives@spatialteq.com or Jason Henderson jhenderson@spatialteq.com

This entry was posted in Business Mapping Software blog post and tagged , , . Bookmark the permalink.

Leave a Reply