Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Make a Treemap in Microsoft Excel

Date:2019-8-20 Author:Cordelia

Treemap is a simple chart in which you can see the value of each item from the spreadsheet clearly and intuitively. It’s a little bit like pie chart but not that focusing on showing each item’s share of the total. If you’d like to try creating a treemap in your Excel file, here’s the method:

First, open the Excel file and select all the cells in the table.

How to Make a Treemap in Microsoft Excel

Switch to Insert tab.

How to Make a Treemap in Microsoft Excel

Find Charts section and click the small arrow in the bottom right corner to open the Insert Chart window.

How to Make a Treemap in Microsoft Excel

Switch to All Charts tab, choose Treemap in the list.

How to Make a Treemap in Microsoft Excel

Place the cursor over the imagine on the right. You can see a preview for the treemap.

How to Make a Treemap in Microsoft Excel

If it’s good enough for you, click OK and it will be actually inserted to your Excel sheet.

How to Make a Treemap in Microsoft Excel

You can click the chart and hit the small icon of paint brush on the right to adjust its style and color.

How to Make a Treemap in Microsoft Excel

This is the simple guide to make a treemap in Microsoft Excel.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *