How Do I Color Code My Business Location Data?

Another common Map Business Online Chat inquiry centers around color-coding imported address data points. Any address or Latitude/Longitude dataset imported into Map Business Online can be color-coded by symbol.  You can also color-code by map layer (ZIP code, county, Census tract).  So, by all means, add extra columns to your data for color-coding.

Your spreadsheet should include columns for Name | Address | City | ZIP code | Sales | Sales Rep | any other data you want to include. Read more about importing data here.

Business map user color-code and symbolize their imported layer for a variety of reasons which could include:

  • To differentiate location points by type of business
  • To display ranked sales by rep or account
  • To quickly identify where a field person starts their day

Color Code with Symbols

Keep in mind, in Map Business Online, when using the Color Code by Symbols button (the three colored dots), you can only color-shade your points and symbols by one theme or one column of your data. For example, you can color-code points based on Revenue 2018. But you can’t color-code by both Sales Rep and by Revenue 2018.

If you want to color-code by two or three themes or variants use the Color-code with Circles or  Put Charts on the Map options. Both are buttons on the master toolbar. See below.

That being said, you could color-code a set of imported addresses by Sales Rep and then note the Revenue 2018 in the point’s label. You could also note the revenue by state, county, or territory in those respective labels. Those revenue numbers would be totals, aggregated by jurisdiction. Map Business Online’s labeling function will sum the data for you. Each jurisdiction label, and each imported point callout has five flexible label fields for you to populate. That’s in addition to name and address data labels.  Read more about labeling here.

Most of the time you will use the Color-Code with Symbols button on the master toolbar to color code points. Map Business Online lets the user color and symbolize with a range of up to 100 colored symbols. That’s plenty. Any more than that and you’ll lose your map audience’s attention (first their eyes glaze over, then they start to drool.)

Within the color-code by symbol dialogue the business map user can:

  • Adjust coloring shades of symbols – Map Business Online even accepts HEX number id’s
  • Choose symbols from the library or import your symbols
  • Adjust color-shade range values
  • Choose from preselected coloring schemes

Best of all, it’s wicked easy to tweak. Just click the Color-Code with Symbols button again to adjust the coloring scheme to your liking. It remembers what you did.

Remember, if you want to represent three separate columns of revenue covering three years, select the Color Code with Circle or Put Charts on the Map buttons. These buttons allow you to select two or three comparative columns and adjust the data symbol intensities and chart options, creating obvious comparative visualizations for your map viewers.

Try Map Business Online Desktop Apps for Windows or Mac – Faster, Better, Cooler

Color Code Map

But wait. You could also uncheck you imported Data Layer in Map and Data and color-code map layers and territories based on imported data columns. The same rules apply, but this time your color-shading will be applied to ZIP codes, State, Counties, or Territories. Read more about Color-Shading ZIP codes etc. here.

In some business circles, the color-shading of administrative districts like ZIP codes is called heat mapping. In Map Business Online we include our Heat Mapping option, which simply plots graduated intensity colors based on numeric values in a column of your data. Use the Heat Map button on the master toolbar to try that out on your map.  This is a great way to display sales figures because it quickly shows the most intense areas of activity. And it’s a great way to wake up that drooling audience (see ‘drool’ above.)

Color-Code Map is also a way to access Demographic Data for color-shading a map layer. For instance, you could color code the ZIP code layer on a map by population levels in each county, or you could color-shade the city limits layer by medium income.

Just as with color shading by points the Color-Code Map dialogue provides controls over summation by map layer, exact color, data source, number of ranges, color applied to areas with no data, and it offers preselected color schemes.

Color-Code Map functionality is also reachable through any map layer settings gear in Map and Data. It’s nice to have multiple ways to get to the same operation across the program.

Single Symbol & Color for Imported Points

You will notice, as you import your business data the application automatically assigns a color and a symbol to your data.  You’ll see blue dots or circles at 50% presentation size on the map after import.  To adjust these points to a new color or symbol, without a creating a whole color-coding scheme, simply select the imported layer in Map and Data and click the edit settings gear – here you will find a symbol selector and a color and size adjustment tool.  You will find the same adjustment tools in the Data Window when the data layer is selected.

Same Bat function, two Bat places

Use these selectors and adjusters to tweak the point layer on the map – change from one color for all points to another color. Change the size of all points. Or choose a new symbol for all locations. But if you want to apply a full color-coding and symbol variation scheme, return to the top of this blog.

Import You’re Own Symbols

In all of the above scenarios, where the symbol library is available, you have the option to import your own small Jpeg symbols. Place your cursor in the Symbol Selector as if to select a new symbol. But instead of selecting a symbol, push the scroll bar on the right to the top. There it is – the ‘import your symbol’ function.  It’s pretty self-explanatory. Before you go further, go make or find a symbol online or at a yard sale or in the back of a magazine at the barbershop. Once you’ve got your custom symbol, go back to the scroll bar and import it.  Now it is in your library of symbols for you to access.

The import symbols process is one way to drop a logo on the map, depending on file size.

These are the straight forward approaches to color-coding and symbolizing your imported data in Map Business Online. Now let’s clean up that drool.

Value-Added Resellers – Offer the tool to your customers as a reseller. Make money on training and consulting. Contact us with further interest in reselling Map Business Online.

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

America’s best geo mapping software.

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.  Discover Map Business Online – tools for making maps by map makers.

 

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

Leave a Reply