Choropleth Map Templates elsewhere

Amendment #4 to Choropleth Maps with Excel: Map Templates for Romania and England

Choropleth Map Romania - click to enlargeIt turned out to be choropleth map summer here on Clearly and Simply. Originally I planned to have only two posts on choropleth maps with Microsoft Excel here and here.

Surprisingly the templates were very well received by the readers: I have noticed an unusual high amount of page views and downloads. Some readers obviously took the templates like a duck to water, produced their own maps and were kind enough to allow me to share the workbooks here (see Paulo’s map of Portugal and Gabriel’s map of Brazil).

Choropleth Map England - click to enlarge

Jeff Weir, member of the month in July 2009 over at Chandoo's blog, wrote a thorough, inspiring and funny guest post called We can’t cure cancer, but we can cure this medicare chart [Chart Busters]. Jeff obviously doesn’t like Choropleth Maps very much (and mentions a couple of good reasons in his text), but he was kind enough to include a link to my article Choropleth Maps with Excel. Many thanks, Jeff.

Furthermore, other bloggers recently published new templates:

Fabrice Rimlinger (of Sparklines for XL fame) posted a map template of Romania and Phil Quinn offered a map of England by ceremonial counties for free download.

Many thanks to Fabrice and Phil.

Many thanks again go also to Tushar Mehta who made all these choropleth map templates possible by sharing his brilliant idea here.

I have to admit that I am not using choropleth maps very often for my own work. However, because of the great response I received from all of you, I decided to stick to this topic a little longer: I am planning to publish another 2 or 3 posts on choropleth maps during the next weeks, before we will continue with new ideas, dashboards and visualizations here on Clearly and Simply in September.

Stay tuned.

Comments

9 responses to “Choropleth Map Templates elsewhere”

  1. Jeff Weir Avatar
    Jeff Weir

    Hi Robert. I might have sent a few readers your way from a guest post a month ago over at chandoo’s PHD blog over at http://chandoo.org/wp/2009/07/24/medicare-chart-critique/
    Been enjoying this series. Look forward to more.
    Jeff

  2. Robert Avatar

    Jeff,
    many thanks for your comment and for pointing to your excellent guest post on Chandoo’s Pointy Haired Dilbert.
    Actually I am an avid reader of Chandoo’s blog and of course I have read and enjoyed your post. I also noticed the link to Clearly and Simply, but I simply forgot to mention your article in my post above.
    My bad. I updated the post now.

  3. jeffrey Weir Avatar

    Hiya Robert. Thanks for the kind words about my guest post. Re my thoughts on Choropeths…I’m not really against them; rather, in my guest post I was mainly pointing out that the one I reviewed was a really misleading one, besides being possibly not the best tool for the particular task.
    Regards
    Jeff

  4. ray Avatar
    ray

    anyone has a template for The United States by state WITH Alaska and Hawaii (not by county)?

  5. Robert Avatar

    Ray,
    download a svg file from Wikmedia Commons like this one:
    Map of USA on Wikimedia Commons
    and follow the steps described here:
    Build your own Choropleth Maps with Excel

  6. Unicorn Avatar
    Unicorn

    Hello Robert!
    compliments for your website!!!
    I downloaded your file “romania map” , you did real a great job.
    I copied the 3 sheets + the macro in a new file excel, but it doesn’t work while using your file it works perfectly.
    How can I integrate your map in another file? sorry but I am not so good with macro and so on…i am still learning…:-)
    Thanks

  7. Robert Avatar

    Unicorn,
    thanks for your message.
    There are different possible causes for the problem, but my first assumption would be: some of the named ranges are missing or incorrect. You have to define the named ranges “MapNameToShape”, “MapValueToColor” and one name for each data cell, like “Alba”, “Arad”, “Arges” etc. in the Romania map example. Go to the Name Manager and make sure all those named ranges exist and refer to the correct cell ranges.
    If this does not solve your issue, you can send me your workbook by email (email-links at the top of the blog) and I will have a look.

  8. Andrei Avatar
    Andrei

    a valid link for the Romanian map?

  9. Robert Avatar

    I can’t reproduce your complaint. The link is valid.

Leave a Reply

Your email address will not be published. Required fields are marked *