How to Create Treemap Chart in Excel - Practical Guide

Learn to create a Treemap chart in Excel to visualize hierarchical data through nested rectangles. Treemaps are ideal for displaying part-to-whole relationships and comparing categorical data sizes at a glance, making complex datasets more intuitive and visually compelling.

Why This Matters

Treemaps enable professionals to communicate complex hierarchical data efficiently in dashboards and reports. This skill enhances data storytelling and makes presentations more impactful.

Prerequisites

•Familiarity with Excel data organization and basic charting
•Data structured with categories and corresponding numerical values
•Excel 2016 or later version installed

Step-by-Step Instructions

Prepare your data

Organize data in columns with category names and corresponding values. Include a hierarchical structure (parent-child relationships) if needed for nested categorization.

Select data range

Highlight all data including headers: click the first cell, drag to the last cell containing data, or use Ctrl+Shift+End to select the entire range.

Insert chart

Navigate to Insert > Charts > All Charts (or Insert > Charts icon in ribbon), then select Treemap from the available chart types.

Customize chart appearance

Right-click the chart and select Chart Design or Format to adjust colors, labels, legend position, and title using the Chart Tools options.

Add chart title and finalize

Click the chart, go to Chart Design > Add Chart Element > Chart Title, enter a descriptive title, then click outside the chart to deselect and view final result.

Alternative Methods

Using recommended charts

Select data and use Insert > Recommended Charts, which may suggest Treemap based on your data structure. This streamlines chart selection.

Creating from pivot table

Build a pivot table from your source data, then insert a Treemap chart directly from the pivot table for dynamic, summarized visualization.

Tips & Tricks

✓Use contrasting colors for different categories to improve visual distinction and readability.
✓Keep category names concise to prevent label crowding within rectangle boxes.
✓Organize data by value size for intuitive visual hierarchy that's easier to interpret.

Pro Tips

★Apply a gradient color scheme in Format Data Series to show value intensity; darker shades represent larger values.
★Use data labels sparingly; enable only for key categories to maintain clarity without visual clutter.
★Combine Treemaps with filters or slicers in dashboards to allow interactive exploration of hierarchical data.

Troubleshooting

Treemap option not available in chart menu

Ensure you're using Excel 2016 or later; Treemaps are not available in older versions. Update Excel or check your version compatibility.

Chart shows empty or incorrectly sized rectangles

Verify all values are numeric and positive; Treemaps don't display zero or negative values properly. Clean your data and remove invalid entries.

Labels are overlapping or cut off

Increase chart size by dragging corners, reduce font size via Format Axis, or display labels only for larger categories.

Related Excel Formulas

SUM SUBTOTAL AGGREGATE

Frequently Asked Questions

Can I create a Treemap with hierarchical data (nested categories)?

Yes, Excel Treemaps support hierarchical data with parent-child relationships. Ensure your data has multiple columns representing different hierarchy levels, and Excel will automatically structure the nested rectangles accordingly.

What's the difference between a Treemap and a Sunburst chart?

Treemaps display data as nested rectangles in a flat layout, while Sunburst charts show hierarchy in concentric circles. Choose Treemaps for side-by-side comparison and Sunburst for radial hierarchy visualization.

Can I change colors based on data values?

Yes, right-click the chart, select Format Data Series, and enable color gradient options. This allows colors to represent value intensity, making patterns immediately visible.

How do I export a Treemap chart as an image?

Right-click the chart and select Save as Picture, or copy the chart (Ctrl+C) and paste it into other applications. Excel preserves formatting and quality in both methods.