Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also been either removed or changed. Therefore, I had to remove all examples of VizMap applications I had created. I didn’t remove the entire topic as I thought some of the code may still be useful with some modifications. 

Navigating using quicklinks and categories

Try it out first ?

For a summary step by step explanation see How to add quickLinks to a Map
If you just want a to try it, then you can download the example application (googleMapping.xlsm) and come back here laterFirst you should take a look at Adding markers to Google Maps from Excel since this is just an enhancement of that.

Category Filter

The javascript necessary for these enhancements is created from Excel as usual, and a new column is available to categorize your placemarkers. You can have as many categories as you want, and they can be whatever text you want. You can also have multiple columns of categories. Here is the example setup in the VenueMaster Tab of googleMapping.xlsm. Im using two category filters – venue size and country.

You will also see that the geoCoding Parameter Sheet needs to know the name of these columns if you are going to use filtering. You can change the column name to a list of columns that you want to filter on.
This generates this on the map
Selecting a category will hide all the markers apart from those belonging to the filters selected. The filters are additive.
If you dont want or need this, you can modify the body code in the geoCoding parameters sheet to remove the <DIV> – combocategory


The quicklink combox box contains a shortcut to each marker. Selecting a marker will navigate to that marker and bring up its infowindow

If you dont want or need this, you can modify the body code in the geoCoding parameters sheet to remove the <DIV> – comboquicklink

Starting on a particular category

If you want to start with a particular category selected, you can add a column to your data that looks like this. The first category name it comes across in this column will be the one on which it opens the map/ Note that if this applies to only the first of your category filters (you may have multiple).

Bounding Box

A bounding box attempts to set an appropriate zoom level for the data being shown – here is the code.

Complete Code

Here is the code, including the data, that is generated from Excel for the VenueMaster Example

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, or read more about Overlaying circles and heatmaps or Mapping and adding markers to maps