Always wanted to make treemaps in Excel and found them to be elusive? Look no further.
Excel Treemap Add-In
Add data to a spreadsheet. Select data range. Two Clicks. As simple as that. No need to have an installation, no need for an internet connection – simply paste data in an Excel spreadsheet and create amazing treemaps.
The product is shipped as an Excel add-in (.xla). The treemap option is accessible as a menu option in Excel 2003 and earlier and as a new ribbon tab in Excel 2007 and later.
1. Squarified or Best Fit Direction – Option to choose between squarified or best-fit treemaps. Squarified treemaps tend to have aspect (height/width) ratios of close to 1 for each node.
2. M x N Input Data Range – The input data can span across multiple columns and rows. (overall limit – 32,000 unique items at each level, no limit to items across data range)
3. Draw Colored or Black & White – Ability to draw the treemap in color or in black & white.
4. Color at specific Level – Option to color the treemap nodes at any specified level – from the 1st to the N(max) level.
5. Color Using Custom or Excel’s Inbuilt Palette – Option to use either the custom-built palette or the default excel palette when creating the Treemaps. If the default color palette has been modified by the user, the Treemap will use those colors if the “Use Colors from Excel’s Palette” has been turned on.
6. Named or without Names – Ability to draw treemaps with or without names being assigned to nodes.
7. Name at specific Level – Ability to specify names to appear only at the specific level.
8. Option to Add Parent Name to Name – Choose whether you want to add the parent name to the child nodes.
9. Size – Chose the size of the treemap and choose the size that best fits your needs.
10. Position – Ability to automatically position the treemap in the worksheet.
11. Header or no Headers – Option to plot with or without data headers.
11. Plots All Nodes – Parent and Child – All nodes are plotted – even the ones hidden below the child nodes.
12. Call From Outside Procedures or Functions – You can integrate the treemap by simply calling the TREEMAP function from any of the your modules and supplying the parameters.
13. Proportionate Borders – The border of a node in the treemap will be proportionate to the level of the node when drawn without colors.
14. Tooltips – When you hover over a node, the tooltips provide useful information about the node.
How Does the Treemap Utility Work
Using the utility is easy. After you’ve added to add-in to Excel, depending upon the version of Excel you are using (Menu in Excel 2003 and earlier and the Ribbon in Excel 2007 and later), you will see the Treemap option appearing on the toolbar.
Use the ribbon using Excel 2007 (and later versions) and the menu toolbar in Excel 2003 (and earlier versions) and select from the two options: Simple Treemap or the Change Treemap
This option allows you to create treemaps where similar nodes will be shaded using the same color for easy identification. You can also 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.
This option allows you to create treemaps where nodes are colored based on the criteria specified. The second last column specifies the size of the node while the last column specifies the hue to use. 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 goes from dark Red to white and then to 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.
Select the data range, choose the options that you prefer and click ‘OK’. The finished treemap will be placed in a new worksheet. Using the options provided, you can choose to draw it square or use best-fit, add names, color, suffix parent node identifier, add or remove headers and modify the position & size of the treemap.
The last column of the data range has to contain numeric values. The area of each node in the resulting treemap is proportional to the value of the node in the data range.
Please refer to full size treemap examples
A few quick examples are given below:
1. Squarified vs. Non-Squarified Treemaps – The treemap on the left is a squarified treemap. Each node of the squarified treemap has an aspect ratio close to 1. The one on the right is a non squarified treemap.
4. A Change Treemap with positive color values The size of the node represents the value of the metric while the color provides an additional level of information (such as rate of change, per capita income etc etc)
5. A Change Treemap – with Negative and Positive Coloring
6. A Colored Treemap with Named Nodes
Buy the Excel Treemap Add-In
As simple as making the treemap. Click on the link below. You will be taken to a page where you can enter the quantity. After you enter the details, you will be taken to a secure payment gateaway (powered by www.paypal.com). Please provide the details and an automated order will be generated for you. (Price per license $15)
To buy, click on the button below:
Once your order has been processed, you would be directed to the download page. You will also be sent a email with the confirmation of the payment and a link to the download page. The process is secure, reliable and fast. If you have any difficulty at any time during the process, please feel free to write to me at firstname.lastname@example.org
Documentation and Installation
Click here to read the complete documentation regarding the Excel treemap add-in. It has been tested to work with Excel versions – 2000, 2003, 2007 and 2010 (windows versions).
If for some reason you are not satisfied with the purchase, you enjoy a 30-day unconditional guarantee – no questions asked. Please write to me at email@example.com and the purchase amount will be refunded.
1. An inherent issue with how shape objects are labelled in some versions of Excel 2007 (and not in Excel 2003 or Excel 2010 beta), may cause the treemap node captions to extend beyond the node borders. The utility allows the user to choose and set a lower font size so that this can be alleviated.
2. While the utility has been enabled to support non-english language characters, it has not been possible to test it across all language sets and locales. In case you face any issues with your specific language customization, please let me know at firstname.lastname@example.org. In case you are not sure whether a particular language set would be supported or not, please try the demo version.
3. Mac versions of Excel are not supported at present.