Clearly and Simply

Category: Choropleth Maps

  • Choropleth Map Template Brazil

    Amendment #2 to Choropleth Maps with Excel: a Map Template for Brazil including an alternative approach

    Choropleth Map Brazil - click to enlargeOnce more a Choropleth Map Template arrived (see also Paulo’s Portugal Map).

    This time Gabriel Eiras Villa kindly contributed a choropleth map of Brazil:

     Download Choropleth Map Brazil (Microsoft Excel 2003, 129.5K)

    But Gabriel has even much more to offer and share. He had a brilliant idea of how to simplify Tushar Mehta's approach:

    Gabriel suggested to use one color (e.g. black) and simply change the fill color transparencies of the shapes according to the values of the regions instead of defining a color gradient table and assigning different shades of grey.

    (more…)

  • Choropleth Map Template Portugal

    Amendment #1 to Choropleth Maps with Excel: a Map Template for Portugal

    Choropleth Map Template Portugal - click to enlargeThe set of choropleth map templates published in my recent post was well received by the readers of Clearly and Simply.

    Paulo, one of my few but faithful readers from Portugal sent me an email including a choropleth map of Portugal by districts. He was kind enough to allow me to publish it here and share it with you:

    Download Choropleth Map Portugal (Microsoft Excel 2003, 196.5K)

    Muito obrigado, Paulo.

  • Multicolored Choropleth Maps with Excel

    The Pop, Soda or Coke Visualization with Microsoft Excel

    Multicolored Choropleth Map - click to enlargeThe previous post discussed Choropleth Maps in general, briefly described how to implement them with Microsoft Excel and provided a couple of templates for free download.

    The post was focused on the classic version of a Choropleth Map, visualizing the measurements of a statistical variable in different geographical regions on a map by color intensity: the greater the measurement, the darker the color.

    The classic version is limited to one variable. This follow-up post describes how to enhance a Choropleth Map in order to visualize more than one variable by using several colors and includes the visualization of “The Great Pop vs Soda Controversy” as an example for free download.

    (more…)

  • Choropleth Maps with Excel

    A Set of Choropleth Map Templates for Microsoft Excel

    Choropleth Map Templates - click to enlargeThe dashboard of Lithuania at a glance used a county based map of Lithuania to visualize the geographical distribution of the population by color intensity: the darker the color, the higher the value.

    Very often, this type of geographical visualization is called thematic map, heat map or statistical map. The less known, but correct expression however is Choropleth Map.

    The idea of how to create Choropleth Maps with Microsoft Excel – as brilliant as it is simple – is the brainchild of Tushar Mehta, Microsoft Excel MVP. I simply “borrowed” his idea and code and put it to effective use on the Lithuanian Dashboard.

    Many readers of Clearly and Simply have been interested in this technique, but unfortunately I was not allowed to provide an unlocked workbook of the Lithuanian Census Dashboard (see comments on Lithuania at a glance). That’s why I thought it might be a good idea to write this post including a couple of templates for Choropleth Maps with Microsoft Excel for free download.

    (more…)