Treemap Charts are one of the many new Charts available only in Excel 2016.

They are very visual as it can easily show you patterns, like based on your summary of sales grouped by month.

The tree branches are represented by rectangles, wherein each rectangle’s size would denote how big the value (in this case, Sales) would be.

The treemap chart would  show each category in each unique color to make it easy to differentiate between each other.

In this example I show you how easy it is to insert a Treemap Chart using Excel 2016.

To upgrade to Excel 2016 you can use this link here: Microsoft Office 2016

 

DOWNLOAD EXCEL WORKBOOK

STEP 1: Highlight your summary table and go to Insert > Recommended Charts

Treemap Chart 01

Treemap Chart 02

 

STEP 2: Select All Charts > Treemap> OK

Treemap Chart 03

 

STEP 3: Now you have your Treemap Chart.

Treemap Chart 04

 

STEP 4: You can further customize the look and feel of your Treemap Chart, by going to Chart Tools > Design / Format

Treemap Chart 05

 

STEP 5: In our example, let us go to Chart Tools > Design and pick one of the alternate designs.

Treemap Chart 06

 

Now you have your beautiful looking Treemap chart and you can quickly point out to your management where the regions with the biggest Sales are…

Treemap Chart 07

Treemap Chart

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Excel Chart Layouts When you create an Excel chart you can choose from 11 different custom Chart Layouts. This is handy if you are pressed for time and want to create a Chart with all its bells and whistles with a press of a button. From this selection you can show your Chart with or without t...
Create a Waterfall Chart With Excel 2016 Waterfall Charts are one of the many new Charts available only in Excel 2016. They are very popular in the current corporate environment as they graphically show the positive and negative movements within your Monthly Net Profit or Cash Flow. When I was working at General E...
Benchmark Chart in Excel 2013 Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark in a graphical way, highlighting the strong v weak months. There are a few steps but in Excel 2013 it has been made much easier to create these charts with the new Combo charts. ...
Apply Custom Chart Styles Excel's default Charts are bland and ugly but you can certainly spice them up to your liking. Using the Shape Styles group in the ribbon menu you can customize your Excel chart the way you or your boss wants. There are several formatting options including Shape Styles, Shap...