I am supporting CandidateX

CandidateX is a startup that focuses on creating inclusion-focused hiring solutions, designed to increase access to job opportunities for underestimated talent. Check them out if you have a few minutes to spare. They need visibility!

This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on flightPaths can be found at Adding flight paths to Maps


What you need

GoogleMapping.xlsm from the Download Complete Projects page



To be able to quickly jump from spot to spot on a map created by How to put markers on maps



All Mapping activities,  are controlled by 2 parameter sheets. One is general, and tells the procedures how to deal with the data returned from the various mapping providers (geoCodingParameters worksheet) and the other is specific to particular sets of data or desired results (in this case ‘step by step parameters’)

  • Hit the markers button and the plotted map will have different colored lines joining the appropriate markers.


  • No more steps. That’s all there is to it.


What just happened ?

javaScript code to create these icons was generated as part of the How to put markers on maps process. If you do not want this to be displayed you can amend the web page template according to the instructions at Adding flight paths to Maps or simply do not include a markerSize or markerColor column in the data, or set the flightGroup to empty for any markers you dont need connected. As with all data items, the name of the column in which to find this data  is tailorable.


What Next

Read more about the detail of how all this works and walk through the source code at Mapping and adding markers to maps , and Adding flight paths to Maps or see some more Step by Step Guides (see below for the full list). 

In the meantime why not join our forum, follow the blog or follow me on twitter to ensure you get updates when they are available.


More Step by Step Guides