Icons
Icons
Icons
How to Turn a Google Sheet Into a Live Map
How to Turn a Google Sheet Into a Live Map
October 5, 2026
How to Measure Distance Between Many Locations
How to Measure Distance Between Many Locations
October 7, 2026

How to Color Code Your Map Markers by Category

October 6, 2026

Map your data in minutes with Maptive

10-day free trial No credit card required

Start Free Trial

On an account or job map, you may need to recognize each location's owner, account type, or status as you look across the pins. Color coding can help you read those categories without opening every marker. The colors need to mean something clear to the person using the map, including someone who hasn't seen the source spreadsheet.

Choose one clear category field

Decide what the colors should mean. You might want to separate customers from prospects, show the rep responsible for each account, or distinguish job statuses. Use one column that answers that question, with a clear category value for each relevant row.

Keep the location and ID fields alongside it. The category tells you how to style a record, while the address or coordinates tell Maptive where to place it. An ID helps you find that same record in the source when you need to check a group assignment.

If you're starting with a spreadsheet, keep its header row and category column in the data you import. Check the location matches during setup so the records appear where they should. If you already have a map, inspect the category values in its data before opening the grouping controls.

Clean up accidental differences in the source labels. A misspelled rep name, a trailing space, or two versions of the same status can make the group list harder to understand. Decide on the intended labels and correct the source values. Don't rely on the map to merge wording that happens to mean the same thing to your team.

Handle missing categories deliberately. If an account hasn't been assigned, a clear “Unassigned” value may be useful for review. Keep that distinct from a record whose category hasn't been checked. Choose labels that help the reader understand the actual state of the data.

Use numeric values differently. A sales column with many different amounts shows how much each location represents. Turning every amount into a separate named category gives you a long key with little practical use. Keep category colors for categories and use numeric ranges when you want to compare quantities.

Group markers by category in Maptive

Open Map Tools and choose Grouping Tool / Colored Pins Tool. Select the category column you prepared. That field appears as the Primary Group, and Maptive colors the mapped pins by its values.

Read the group names before changing any styles. Check that the categories you expected are there and look for names that suggest an accidental source variation. If the group list includes two versions of the same rep or status, correct that problem before choosing colors for both.

Open a few markers and compare their category fields with their groups. Include records from different categories, along with a record that has a missing or unusual value. This gives you a better check than assuming the colors are right because the map looks organized.

Use the group checkboxes to select or deselect the visible primary and secondary groups. Hiding a group can help you inspect another group's locations in a crowded region. Turn the relevant groups back on when you finish the check, especially if the finished view is supposed to show the full list.

The category choice itself creates the category grouping. You don't need to add Group Now to this sequence. That control belongs to the numeric-range setup, where you choose ranges and marker settings before generating the groups.

Give categories readable marker styles

Change the whole group

Click the white marker icon to the right of a group to customize its style. The group's location-pin icon opens Group Marker Settings. Make the choice there when all records in the category should use the same appearance.

Choose colors that remain distinct against the map background. Check a marker over a busy street area and one over a less crowded background. A color that looks clear in the settings can become difficult to see once roads, labels, and other markers surround it.

Give the category another recognizable cue where useful. A marker style or shape can help distinguish groups, while the category name in the key or popup provides the text explanation. People should have a way to understand the group when they can't easily distinguish its color.

Keep the meaning consistent across related maps. If a particular color represents active customers in one view, use that meaning in the next view people will compare with it. Make those choices deliberately and check them after updates, rather than assuming every map will preserve the same choices on its own.

If the list has many categories, consider which distinctions the current task needs. You may be able to use a broader, clearly defined category in the source for a summary map, then inspect the detailed categories separately. Preserve the original detail where it's needed. Don't merge business categories merely to make the palette easier to choose.

Check the key after styling. Its names and symbols should explain the markers someone sees in the map. A readable palette helps, but the labels and available text need to do their share of the work.

Use individual overrides sparingly

For a single marker, open the marker, click the Settings and Customization icon, and choose Customize Marker. This can be useful for a deliberate exception, but individual changes have two drawbacks when the map's meaning comes from categories.

Those changes don't appear in the key, and they can be overwritten when the data reloads. A viewer may therefore see a special-looking pin without an explanation, or the pin may lose its special style after an update.

If the exception matters to the analysis, consider representing it in a source field that can be grouped. That lets you inspect the reason for the difference in the data and show it in the key. Keep the original category if the exception answers a separate question.

Overall marker defaults have their own controls. Go to Map Settings, then Map Markers / Graphics, and use Map Marker Style or Customize Map Markers. Upload Custom Marker lets you use your own image or logo. These choices can help set the general appearance, while group settings handle differences tied to category values.

Add a second field only when it helps

A Secondary group can accompany the Primary Group. Use it when the reader needs another piece of information at the same time, such as account category together with a numerical sales measure.

For a numeric field, the grouping workflow opens a ranges popup. Choose the number of groups and whether to use percentages or number ranges. Marker choices include Blue bubble, Multi color bubble, and Growing pin, with a fill color choice. Click Group Now after setting up the numeric view.

Numeric bubbles can show magnitude alongside the primary category colors. Make sure the key explains both fields, including the numeric ranges. A reader should be able to tell which visual choice identifies the category and which represents the quantity.

If the second grouping makes the markers harder to distinguish or creates a key people struggle to use, return to the simpler category view for the current task. You can inspect the numeric question separately without changing what the category field means.

Check the map at its working size

Inspect the map at the zoom level and screen size people will use. Start with the group labels and counts, then compare a few records with the source. Check that each sample's category matches its marker and the key.

Zoom into dense locations and selectively show groups. Several records can share one address, so overlapping pins don't prove that rows are missing. Use the data and category fields to check those records rather than counting only the symbols you can see at a wide zoom.

Read a popup from each important category. The name and category text should help someone identify the location even when the colors are difficult to distinguish. If you're sharing the map, check that the recipient view includes the key and the fields needed to understand it.

After a data reload, inspect the group list again. Check for new labels, unexpected missing values, and any individual styling you had applied. Check a newly introduced source label before people treat it as an established category.

Finish by checking a record whose category has changed. Confirm its new value in the mapped data, find it in the intended group, and compare its marker with that group's key entry. That gives you a concrete check that the color coding still follows the field you chose.

✕