Categorized | excel chart, excel download
Tags |

Treemap Add-In For Excel – Treemap Software Demo

Treemaps are an interesting way to look at data. Here is the first preview of the treemap add-in for excel. Being a demo, the number of data points are limited to 50.

Here the a demo file containing the treemap add-in for Excel. (The demo treemap version is limited to a maximum of 50 rows and is meant for evaluation purpose only. The full version does not contain this restriction.)


If you like the demo, Buy the full version here.


(Please Note: Since changes are regularly made to the Treemap utility, the information contained on this page may be outdated at times. Please use the Treemap home page to review the latest changes.)


Download the excel workbook given at the end of the post. The demo will work with Excel 2003, 2007 and 2010.


When you open the workbook, you will see a new menu item being added to the toolbar with two options to choose from : ‘Simple Treemap’ and ‘Change Treemap’


Simple Treemap

The simple treemap option allows you to create treemaps where similar nodes are shaded using the same color for ease of identification. You can choose to color nodes at any level of the input data. Bear in mind that the last column should contain numeric and positive values.

Here is a sample treemap created using the simple treemap option.

Change Treemap


This change treemap option allows you to create treemaps where nodes are colored based on the criteria specified in the last column. The second last column specifies the size of the node. Bear in mind that the last two columns should contain numeric values and the second last column should only have positive values. The last column specifies the color and it ranges from dark Red to White and then onto dark Green indicating a range from the most positive to the most negative. The last column can be anything that you would like to use – rate of growth, per capita income or anything that can help you analyze the data better.

Here is a sample treemap created using the change treemap option.

The documentation can be accessed here.

Update: I finally mastered the squarification technique. Squarification produces an aspect ratio close to 1 for each node. To a great extent, a higher degree of squarification needs a higher computation time. The squarification algorithm employed in this version is an approximate one and uses the same time to run as the non-squarified one. This relies on a modified form of the “pivot-by-largest” algorithm. Of the two images below, the first one uses the approximate squarification logic and tries to give each node an aspect ratio close to 1. The second one is a treemap where the nodes are plotted in the order in which they occur. The squarification comes into play when the ‘Squarify Treemap‘ option is turned on.


Excel Formula, Excel Chart, Excel Macro, Excel VBA, Pivot Table Excel, Excel Dashboard

What Do You Think ?

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Comments and Trackbacks

  1. Fabrice wrote:

    I just added a squarified Treemap function to my FREE Sparklines add-in.
    You can give it a try :
    I tested it with up to 1500 values.

    Happy 2010 !!

  2. Ajay wrote:

    @Fabrice – I just downloaded the Forbes data workbook and played around with it. I saw that your version produces exact squares and they look nice. I am very interested to know if that increased processing time by any chance? Mine took about 6.5 seconds to process about 2000 rows(single column) with colors and names and about 2.1 secs without colors and nodes. (Quad Core, 3.4 GHz) Another thing that I noticed is that both squarification and non-squarification algos took about that same amount of time. The algo I employ tries to get the aspect ratio close to 1 (but not exact). I use VBA.

    Here’s my version of the treemap with coloring at the country level with each node representing the size of individual companies.

    And here’s the version with only 1 level of data (Companies).

    Wish you a very happy new year as well :-)

  3. Dennis McFadden wrote:

    Hi. Very interesting. I am struggling a bit with one aspect. The basic block diagrams are fine, but when I roll over them , the underlying information does not display. Is that asking too much of this program?

  4. Eric wrote:

    Good enough with tree map information!

  5. John wrote:

    Looks very interesting, but I was not able to get the demo version work with Mac Excel (OS X.10.1 & Excel Mac 2011 v 14.4.6)

  6. Vipin wrote:

    I am interested in creating Treemaps for my data sets. However the demo version is not working for me. It does show me a small glimpse of the map and then a message saying that an error occured while processing appears.
    Please provide feedbcak on possible reasons for this.
    I will go for a full version only after seeing results on the demo.

  1. Treemap in Excel - Coming Soon | Excel & VBA - da Tab Is On wrote:

    […] The Treemap demo can be located here. You can also buy the treemap utility here ($ 15 […]

  2. A Big Thank You | Excel & VBA - da Tab Is On wrote:

    […] fast, easy to use and works well even with thousands of data points. You can check out the latest demo version […]

  3. S’il te plaît, dessine-moi une poldoc (2/2) | Lirographe wrote:

    […] Excel : il existe également une macro Treemap sur Excel, téléchargeable ici (pour installer une macro dans Excel 2003 ou 2007, voir ici). Plus paramétrable que Many Eyes, […]

  4. 5+ Free Treemap Software tools - Butler Analytics wrote:

    […] Excel – A treemap add-in for Excel. Free demo version limited to 50 data points. […]


Keep up with the latest stories - Delivered right to your inbox


English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel