Creating map using vba macros

[Israel lavi]

Hi there!
I'm looking for a solution to a problem I have.
I have a column of states and next to it, a column of values (Numerical).
I'm trying unsuccessfully to create a macros that will represent those countries in a map.
Could you provide me a solution please?
Thanks!

 

[Israel lavi]

I'm using excel 2013 BTW..

 

[Lolo]

Hello, Several possibilities:

* In the excel store there is the bing maps app, that could help you

* Download the add in microsoft power map (still in dev, not supported yet, but very impressive !). very easy to use.
http://www.microsoft.com/en-us/download/details.aspx?id=38395

* Use power view. Bing maps is integrated in it.
http://office.microsoft.com/en-us/e...ng-power-view-reports-part-1-HA104075458.aspx
http://www.ablebits.com/office-addins-blog/2014/01/21/excel-maps/

*Use your own "macro" by developing it by inspiring from the existing work from this wonderful site :
http://www.clearlyandsimply.com/clearly_and_simply/choropleth-maps/

Hope this helps

 

[Israel lavi]

Ok i'll work on it. Thank u so much!!!