The colors are automatically assigned based on the column you set as the Group (see image below). There are up to 20 different colors that are used for premium/pro users and 7 for free. If a column has more than 20 (7 for free maps) unique values, they will be combined together in ranges. It’s best to define the range yourself and use that for the group.
Assign a group to change the pin colors:
After assigning a group the colors can be changed as shown in the above image by clicking on ‘Show Group Markers‘ (becomes ‘Hide Group Markers’ after clicking).
A very real life situation is as follows:
In order to assign different pin colors to two spreadsheets, one with sales reps and the other with potential customers. The spreadsheets need to be combined into 1 and a column (possibly ‘sales type’) needs to be added. The values for the column can be ‘sales rep’ and ‘customers’.