How to display on a map 3 adress columns with 3 different colors for pins

Hello,

I have a Google sheet with rows representing persons. For each row I have stored the name of that person, its birth location, its wedding location and its death location.

Now I would like to display a map with these 3 types of addresses for each person. A green pin for each birth location, a blue pin for a wedding location, and a red pin for death location. I could easily do it with slices if the 3 locations were in the same column, but it's simpler to store them in 3. The map view can only display one data column, and a secondary data column, and I can't even find a way to display the data column and the secondary with different pin colors.

How can I do?

Thanks for your help.

0 4 165
  • UX
4 REPLIES 4
Top Labels in this Space