How to Create and Customise Treemap Charts in Microsoft Excel

Visualising multi-tiered categorical data such as departmental budgets, global product inventory by category and sub-category, or sales breakdown by continent and country often overwhelms traditional pie charts and stacked bar graphs. When dealing with nested proportions, standard charts either run out of distinct colours or compress smaller categories into illegible slivers. In Microsoft Excel, the Treemap chart solves this problem by displaying hierarchical data as a series of nested rectangles, where the area of each rectangle is directly proportional to its numerical value.

Introduced in modern editions of Excel (Microsoft 365, Excel 2021, 2019, and 2016), Treemaps make it easy to compare category sizes and sub-branch contributions at a single glance. In this guide, you will learn how to structure nested hierarchical data for Treemaps in Microsoft Excel, insert the chart from the ribbon, customise tile layouts and label hierarchy, and format colour schemes for high-impact executive dashboards.

Understanding Treemap Chart Structure in Excel

A Treemap organises categorical dimensions into clear visual containers:

• Main Category Branches (Outer Rectangles): The highest level of your hierarchy is displayed as large overarching coloured bounding boxes.
• Sub-Category Leaves (Nested Tiles): Individual items or sub-branches reside inside their parent category box, with their square or rectangular area scaled based on their numerical metric.
• Hierarchical Labeling: Excel displays branch names either in a top banner bar or interleaved among the inner tiles to maintain spatial context.
• No Negative or Zero Values: Because tile areas represent geometric proportions, all values plotted in a Treemap must be positive integers or decimals greater than zero.

Preparing Hierarchical Data for a Treemap

To ensure Excel correctly parses parent-child relationships, arrange your dataset in contiguous columns ordered from the highest hierarchy level to the lowest, ending with the numerical value:

1. Column A (Parent Category): E.g., Electronics, Apparel, Home & Kitchen.
2. Column B (Sub-Category): E.g., Laptops, Smartphones, Audio.
3. Column C (Optional Third Level or Item): E.g., Ultrabooks, Gaming Laptops.
4. Final Column (Metric / Values): The quantitative measure, such as Revenue, Headcount, or Stock Quantity.
5. Ensure there are no blank rows or total summation rows within your selected data range.

How to Create a Treemap Chart in Microsoft Excel

Once your table is organised, inserting the chart takes moments:

1. Select your table range including headers (e.g., A1:C15).
2. Click the Insert tab on the Excel ribbon.
3. In the Charts command group, click the Insert Hierarchy Chart icon (represented by nested rectangles).
4. Select Treemap.
5. Excel instantly generates the chart, grouping related sub-categories into distinct coloured parent rectangles scaled according to their numerical values.

Customising and Formatting Treemap Charts

Default Treemaps can be refined to improve contrast, typography hierarchy, and corporate presentation style:

1. Customising Label Options (Banner vs Overlapping)

1. Right-click any tile inside the chart and select Format Data Series.
2. In the Format Data Series pane on the right, under Series Options, locate Label Options.
3. Choose your preferred layout:
   • Banner: Places the parent category name in a distinct header band across the top of each block, providing a structured, compartmentalised appearance.
   • Overlapping: Displays parent and child labels together inside the tile space, maximising printable area.
   • None: Hides labels, suitable when accompanied by a detailed interactive legend.

2. Changing Colour Themes and Highlighting Categories

1. Select the chart canvas and click the Chart Design tab on the ribbon.
2. Click Change Colours to apply a modern monochromatic gradient or high-contrast palette.
3. To highlight a specific parent category independently, double-click that category’s outer boundary, open the Fill & Line tab in the format pane, and select a custom solid fill colour.

3. Adding Data Labels with Values

1. Click the chart to reveal the Chart Elements (+) button in the top-right corner.
2. Check the Data Labels box.
3. To show both category names and exact revenue numbers inside each tile, select Data Labels > More Options and tick both Category Name and Value.

Treemap vs Sunburst: When to Use Which

Excel offers two primary hierarchy charts. Understanding their design strengths ensures optimal presentation clarity:

Visual Aspect	Treemap Chart	Sunburst Chart
Geometry	Rectangular nested tiles filling a grid.	Concentric multi-ring circular rings.
Best Used For	Comparing relative sizes between 2 or 3 hierarchy tiers where screen space efficiency is paramount.	Emphasising deep structural hierarchies with 3 to 5 nested levels.
Space Utilisation	100% of the chart area is utilized with no empty margins.	Requires empty circular space in corners.
Label Readability	Horizontal rectangular text is generally easier to read.	Radial curved text can become rotated or condensed.

Best Practices for Interpreting Treemaps

To extract meaningful insights from your Excel Treemap visualisations:

• Scan by Area, Not Perimeter: Remember that total tile area—not width or height in isolation—signifies quantity.
• Consolidate Long Tails: If you have dozens of micro-items with tiny values, group them into an “Other” category to prevent micro-tiles that cannot display legible text.
• Pair with PivotTables: Keep the underlying source table linked to dynamic Excel Tables (Ctrl+T) so your Treemap automatically updates whenever new product rows or revenue figures are added.