Add Map Markers of Different Colors via Spreadsheet

Suppose you want to add different colored markers, based on a certain column in your spreadsheet, e.g., to distinguish Hospitals and Clinics.
Add a column called “Category” to your spreadsheet, and then enter values such as “Hospital” and “Clinic” in the relevant cells.

ZeeMaps will automatically assign a different color to each category.
If you want to specify the color yourself, then before you upload the spreadsheet, add a legend using the Map -> Legend menu item. Specify the legend values “Hospital” and “Clinic” for the appropriate colors.

The matching is case-sensitive, so make sure that your legend values and category values are exactly the same.

To delete a legend value, empty the legend value in the Map -> Legend dialog and hit submit.

If you want to color markers differently, but not necessarily have a legend, then you can also use color names like blue, green, yellow, etc., in your spreadsheet cells. For a complete list of colors, see the menu item Map -> Marker Icons on your map.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

This site uses Akismet to reduce spam. Learn how your comment data is processed.