A few days ago I read a Peppers and Rogers report that made intriguing use of a tree map. Tree Maps as a 2-dimensional representation, use rectangles with an area proportional to a specific dimension of the data, while colors can be used to represent another dimension of the data. So I scratched around and found out more about tree maps and heat maps. I found that an add-in for Excel was available. It downloads quite easily from: Link to Excel Add-in Tree Map
I am sure your will be able to install the add-in quite easily. Use the Excel Options by clicking on Office menu button from Excel. Tree Map also made be used independently of Excel.
Finding topical data to test our the TreeMap add-in was easy, I used results of May poll on the Greek elections by the BBC News -Greek election poll
I converted the elections data into a suitable format for Excel Tree Map Add-in. Here is the file
Greek May 2012 Elections Poll Data
Output from the Tree Map add-in can be saved in a variety of formats. Here is my output saved as a JPEG format.
Using relatively simple data set, the visualization is much more exciting. As the data sets get larger and more complex, I expect the emerging patterns will be of more interest. I hope this saves you some time and you share my fascination with the Tree Maps.
And now the results a few days later:
A picture is worth a thousand words. A colorful graphic depicts the swing in vote quite dramatically.
Greek Election Results - BBC News
I am sure your will be able to install the add-in quite easily. Use the Excel Options by clicking on Office menu button from Excel. Tree Map also made be used independently of Excel.
Finding topical data to test our the TreeMap add-in was easy, I used results of May poll on the Greek elections by the BBC News -Greek election poll
I converted the elections data into a suitable format for Excel Tree Map Add-in. Here is the file
Greek May 2012 Elections Poll Data
Output from the Tree Map add-in can be saved in a variety of formats. Here is my output saved as a JPEG format.
Using relatively simple data set, the visualization is much more exciting. As the data sets get larger and more complex, I expect the emerging patterns will be of more interest. I hope this saves you some time and you share my fascination with the Tree Maps.
And now the results a few days later:
A picture is worth a thousand words. A colorful graphic depicts the swing in vote quite dramatically.
Greek Election Results - BBC News
1 comment:
You will note that the color coding of the Greek parties was aligned to their acceptance or rejection of the bail out/memorandum. It will be interesting to compare the results to this opinion poll.
Post a Comment