See these tutorials first:
http://www.clearlyandsimply.com/clearly_and_simply/2012/12/create-excel-choropleth-maps-from-shape-files.html
http://www.clearlyandsimply.com/clearly_and_simply/2009/08/build-your-own-choropleth-maps-with-excel.html
Then download shapefile for Poland from here:
http://www.gadm.org/country
Next, use online service to convert shp to svg file:
http://indiemapper.com/app/
(By the way, you can open svg as xml in Excel and extract a table with columns for Province, County or Major Town - you may need it. )
Convert svg file into emf in Inkscape (free and open source equivalent of InDesign)
You can now open emf in Excel or PowerPoint and ungroup the vector image into individual shapes for each county. Now it will be possible to use VBA to give them colors, values, labels etc.
More info
https://pl.wikipedia.org/wiki/Powiaty_w_Polsce
Translation issues: http://serwistlumacza.com/content/view/27/32/
Another option: http://www.exprodat.com/blogs/blog_Extracting-Vector-Data-from-PDFs.htm using
http://ksng.gugik.gov.pl/pliki/mapa_administracyjna_polski_2012.pdf
Brak komentarzy:
Prześlij komentarz