How to Make a Treemap in Excel

News
By published

Excel 2016's new Treemap chart offers an interesting way to visualize a hierarchy of data. With it, you can compare data for different categories at a glance, such as revenue for a bookstore by book genre and sub-genres or laptop sales by manufacturer and model. Here's how to create a Treemap in just a couple of clicks

1. Highlight the data you want to use for your Treemap.

2. Click the Insert tab.

3. Click the Insert Hierarchy button > Treemap. Excel will create and insert a Treemap chart into your spreadsheet.

4. Double-click the chart to format it. You can apply a chart style, for example, edit the chart title, select a different color scheme, and so on.

When your data is logically categorized and ordered, you can use a Treemap to easily find patterns in that information.

Microsoft Excel Tips

Melanie Pinola

Melanie was a writer at Laptop Mag. She wrote dozens of helpful how-to guides, covering both the software and the hardware side of things. Her work included topics like SSDs, RAM, Apple, Excel, OneDrive, and detailed guides for Windows users. Outside of all her useful advice, Melanie also penned a few reviews for Laptop Mag, including Android emulators that help you run apps on your PC.

More about work collaboration tools

I found an app that connects all my apps — without trying to replace them. It's a life-changer.

Intel Thunderbolt Share: The powerful PC-to-PC connection software is frustratingly elusive, but you don't need a new laptop to use it

Samsung's top-rated Galaxy Tab S6 Lite with S Pen crashes to $199 in time for Mother's Day
See more latest
Most Popular
A Switch 2 Pro controller
If you preordered a Switch 2 you might want to buy a new Pro controller ASAP
Alienware 34 Curved QD-OLED monitor (AW3425DW) against a gradient background.
Alienware's flagship 34-inch curved QD-OLED now features a 240Hz refresh rate
Elden Ring Nightreign gameplay
Elden Ring Nightreign actually runs on your old GPU, and more AAA games need to follow its lead
Four Nothing CMF Phone 2 Pro units back-to-back in black, green, orange, and white on a gray table
Nothing's modular CMF Phone 2 Pro adds one huge feature, but kills one of my favorites
Windows 365
No, Microsoft isn't going to charge you $1.50 to update Windows 11
iPhone 17
Apple's 20th anniversary iPhone might be 'extraordinarily complex' and also extraordinarily expensive
MIAMI, FLORIDA - JUNE 18: A laptop computer with Microsoft Copilot+ installed is on display at the Best Buy store on June 18, 2024 in Miami, Florida. Today, Best Buy began selling Microsoft's new line of AI-centric Copilot+ PCs to customers. The store has the most extensive assortment of Copilot+ PCs in their stores from vendors like Microsoft, Dell, HP, Lenovo, and Samsung. Microsoft Copilot is a generative artificial intelligence chatbot developed by the company. (Photo by Joe Raedle/Getty Images)
Microsoft's controversial Recall feature arrives on Copilot+ PCs, here’s what you should know
Apple Glasses concept render
Apple’s smart glasses are coming—but you’ll have to wait a while
Microsoft Outlook
The Outlook typing lag wasn’t your imagination — Microsoft just explained why
iPhone 15
Apple is racing against time to shift iPhone production away from China to dodge Trump's tariffs