Wednesday 20 July 2016

[ ::: ♥Keep_Mailing♥ ::: ]™ 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:

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


--
You received this message because you are subscribed to the Google Groups "Keep_Mailing" group.
To unsubscribe from this group and stop receiving emails from it, send an email to keep_mailing+unsubscribe@googlegroups.com.
To post to this group, send email to keep_mailing@googlegroups.com.
Visit this group at https://groups.google.com/group/keep_mailing.
To view this discussion on the web visit https://groups.google.com/d/msgid/keep_mailing/CAG%3DbiTtqwmK96weo_KQQ1QR%3DoJshH8jznQVE384z0dRu_c0SCg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment