Blog Archive

Excel: Making Tree Map (For Excel 2016 Only)

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:
https://en.wikipedia.org/wiki/List_of_countries_and_dependencies_by_population
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

 

Post a Comment