Wednesday, 20 July 2016

[HM:258456] Excel: Making Tree Map

Treemap is an easy and beautiful way of visualizing layered data. It represents your data set in a way that is visually pleasing and easy to understand. This post will show you how to create an Excel Treemap.


Following tutorial is showing how to build a treemap chat in Excel 2016. Treemap Chart is not available as a build-in chart type for the versions of Excel prior to 2016.

In our example, I will use the population of countries, grouped by continents. I took the data from:

Arranging data took some time but I managed to prepare this dataset:Excel Treemap 1

Notice how the list is ordered as Continent -> Country -> Population. With this dataset, all we need to do is to select whole data and insert an Excel Treemap. It is located in Inset ribbon along with other charts under "Hierarchy Chart" group.Excel Treemap 2

Click on Hierarchy Chart and then on Treemap to insert an Excel Treemap.Excel Treemap 3

Your chart will be created at that instant.Excel Treemap 4

You can apply some formatting if you choose to. Or select a pre-made style from chart styles menu. Here is the one I use:Excel Treemap 5

You can download this Chart along with the data from this link: Download Excel Treemap Chart

Article Source  Picture Source

We are also on Face Book, Click on Like to jois us
FB Page:
FB Group:

You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
For more options, visit

No comments:

Post a Comment