• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

create an interactive map in excel.

G

greg.begin

Member
I want to be able to put in a list of addresses, they show up as an interactive icon in a map of the USA. then I want to be able to see the icon change based on some KPIs and then click on the icon to get more information. Is this possible with VBA and perhaps google maps. I need the map to be interactive as well, so when I add a new location, it will show up. Help please.
 
To get you started, I'd take a look at this UDF that ashish wrote:
http://chandoo.org/forum/threads/ud...-any-address-using-mapquest-api-and-vba.7341/

The lattitude and longitude you get could be converted into x/y coordinates for a chart. You could set the picture of the USA as chart background, and then a XY series plots points on the chart, overlaying the image of USA, providing info. Clicking on the data points to get more is possible to, with Chart_Select event. For examples on using maps w/ charts, and pop-up info, I'd recommend taking a look at some of the winners from last dashboard contest:
http://chandoo.org/wp/2014/07/07/winners-of-state-migration-dashboard-contest/
 
You must log in or register to reply here.
Back
Top