Treemap Add-in

Excel treemap add-in for presentation and reporting

Excel Treemap Add-in

Rate this solution: (3/5 from 2 votes)

The Treemap Add-in for Excel adds treemap data visualization functionality to hierarchical structured data in Excel. Treemaps display hierarchical data as a set of nested rectangles where each branch of the tree is allocated a rectangle which is tiled with smaller rectangles representing sub-branches of data. A leaf node's rectangle has an area proportional to a specified dimension on the data and leaf nodes can be colored to show a separate dimension of the data. The Treemap Add-in for Excel can create treemap visualizations quickly and easily from a menu option in Excel 2003 and earlier and as a new ribbon tab in Excel 2007 and later. Key features of The Treemap Add-in for Excel include: Squarified or Best Fit Direction: option to choose between squarified or best-fit rectangle dimensions for created treemap. M x N Input Data Range: the input data can span across multiple columns and rows. Draw Colored or Black and White: draws the treemap in color or in black and white. Color at specific Level: option to color the treemap nodes at any specified level from the 1st to the N (maximum) level. Color Using Custom or Excel’s Built in Palette: option to use either a custom palette or the default excel palette to color the treemap. Named or without Names: ability to draw treemaps with or without names being assigned to nodes. Name at specific Level: ability to specify names to appear only at the specific level. Add Parent Name to Name: option to add the parent name to the child nodes. Size: specify the size of the treemap to fit requirements. Position: ability to automatically position the treemap in the worksheet. Header or no Headers: option to plot with or without data headers. Plots All Nodes: All nodes are drawn even if hidden below the child nodes. Call From Outside Procedures or Functions: integrate the treemap by calling the TREEMAP function from other modules and supplying the parameters. Proportionate Borders: the border of a node in the treemap will be proportionate to the level of the node. Tool tips - When you hover over a node, the tool tips provide useful information about the node. (Click the EXCEL TREEMAP menu item at the top of the next page to access this product). Get It (Pricing is available on the next page) (Updated on 2023-12-01)

Related Excel Solutions for Treemap Add-in OLAP ReportingPresentation and Reporting  Enhance Spreadsheet PresentationPresentation and Reporting  Professional Reporting TemplatesPresentation and Reporting  Dashboard ReportingPresentation and Reporting  Waterfall Chart GeneratorPresentation and Reporting

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as Free Excel solutions and the most popular. Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.