Clearly and Simply

Tag: heat maps

  • Create Excel Choropleth Maps from Shape Files

    How to transform Shape Files into Microsoft Excel Choropleth Maps – including 2 Maps of Germany by Zip Codes

    Germany by Zip CodesOn several occasions I thought (and stated) that I already published everything I have to say about Choropleth Maps with Excel.

    Having said that, it seems as if “the ghosts I called I can’t get rid of now”. Recently someone asked me if I could provide an Excel Choropleth Map of Germany by zip codes. Careless and stupid boy I am, I answered “sure this is no problem”. What a misjudgment.

    If you followed my previous Excel Choropleth Map articles, you know that it takes either an Enhanced Metafile of the map you can ungroup in Excel to get the shapes or at least an SVG file to transform it to an EMF file using e.g. Inkscape. 

    And here is the roadblock I encountered: I simply couldn’t find a map of Germany by zip codes in one of the required formats. All I could find were ESRI shape files. After hours of searching for EMF and SVG files, I gave up, simply reversed my thinking and looked for a tool to convert shape files into SVG. 5 minutes later I had the solution.

    Today’s post describes how to use Indiemapper, a free online tool, to transform shape files into SVG which can then be used for Microsoft Excel Choropleth Maps in the well-known way.

    (more…)

  • Fast Choropleth Map with Enhanced Features

    Enhance a detailed Choropleth Map in Microsoft Excel with additional features

    Choropleth Map with enhanced featuresThe recent article Faster Choropleth Maps with Microsoft Excel provided a faster version of the VBA code to update a detailed Choropleth Map in Microsoft Excel.

    Leonid Koyfman, a faithful reader of Clearly and Simply liked this article. Leonid already contributed his invaluable ideas and insights here before (Excel Multiple Value Filters with Invert Selection). He had a couple of very interesting ideas for the fast Choropleth Map and he is kind enough to share them with us:

     

    1. Let the user filter the data by value bin and thereby highlight the bins of interest on the map
    2. Show tooltips when hovering over the map to display the name of the county and the unemployment rate in percent
    3. Let the user switch the level of detail: color the map by county or by state

    Today’s article describes Leonid’s enhancements and includes a link to the Excel workbook for free download.

    (more…)

  • Faster Choropleth Maps with Microsoft Excel

    An improved version of a Microsoft Excel Choropleth Map with a better performance for detailed maps

    Choropleth Map US Unemployment by CountyVery soon after starting this blog in 2009 I published a post with a set of Microsoft Excel Choropleth Map templates.  This post is still one of the most popular articles and downloads here.

    A lot of related posts followed and I am feeling very honored that my blogging colleague and France’s data visualization guru Bernard Lebelle of Impact Visuel used 2 of my maps published here on Clearly and Simply in his great new book “Convaincre avec des graphiques efficaces”. Bernard was kind enough to point his readers to my blog in the book. This is much appreciated. However, he should have heaped the praise on Tushar Mehta, who invented this technique. I only “stole” Tushar’s idea.

    Tushar’s approach works great and I know from comments and emails that a lot of my readers have used it with great success.

    There is only one minor drawback with Tushar’s approach: the performance decreases considerably when using it on a map with a lot of shapes, like the US by Counties.

    Today’s post tries to heal this. It discusses how to considerably improve the performance of a detailed map. The article describes the original approach, the optimization potential, the improved implementation and – as always – provides the Excel workbook for free download.

    (more…)

  • Spice up your Choropleth Maps with Excel

    6 (+1) tips how to mitigate some of the disadvantages of Choropleth Maps in Microsoft Excel

    Spiced Up Choropleth MapWe already had a couple of articles on Choropleth Maps, either using Microsoft Excel or Tableau. To be honest, I was really surprised how well these posts were received by our readers. The workbook provided for download with the first article Choropleth Maps with Excel is still in undisputed first place of all downloads here on Clearly and Simply. Thus, there was quite an avalanche of posts and comments on this topic and – despite the fact that I promised to stop posting on Choropleth Maps several times before – I announced at the end of the latest article that I am having left one ace up my sleeve regarding Choropleth Maps. Here it is and it will definitely be the last one:

    Already back in September last year, Lavih sent me an email including a map template of Argentina based on Gabriel’s implementation using transparencies. With the first email Lavih asked me for an easy way to let the user change the basic fill color of the map. Over a couple of weeks we emailed back and forth and together we developed some ideas on how to improve Choropleth Map visualizations with Microsoft Excel, far beyond only changing the basic fill color.

    Today’s post provides 6 (+1) tips on how to spice up your Choropleth Map visualizations using Microsoft Excel, as always including the workbooks for free download.

    (more…)

  • Build your own Choropleth Maps with Excel

    Amendment #6 to Choropleth Maps with Excel: a workaround to transfer the names of regions from a svg file into xls

    Choropleth Map USA by Congressional Districts - click to enlarge

    In a comment on Multicolored Choropleth Maps with Excel Dave Hammer pointed to a couple of excellent maps on Wikimedia Commons in svg file format (scalable vector format). Dave wanted to use these maps to create choropleth maps with Microsoft Excel, but he hit a roadblock with regards to the texts (names of counties or districts) associated to the shapes in the svg file: after ungrouping the map in Excel, the shapes were available, but the associated names were gone. In his example (counties or congressional districts), it would be a lot of laborious work to assign the names to the shapes manually. And it would be error-prone as well.

    Actually there is a workaround to let Excel do most of the work. This post describes this workaround and provides a template of a choropleth map of the United States by congressional districts for free download.

    (more…)