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 vizMap applications can be found at Data Driven Mapping applications
GoogleMapping.xlsm from the Download Complete Projects page
Data Driven Mapping applications.
You will already have prepared your data, either by joining the transactions to the various master and lookup files as per How to prepare for your vizMap application - Data and How to prepare for your VizMap application - Parameters, or you will have created your matched transactional and locational data in some other way. Now it is time to prepare the vizMap Dictionary.
First open the sheet - step by step parameters. You will see a parameter block as below
VizMap Dictionary see some more Step by Step Guides. 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.
You want to learn Google Apps Script?
Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, available All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly.
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Get Started Snippets > Step by Step Guides >