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



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


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Line Chart: Trend with lots of data A Line Chart is used in Excel when you have lots of data points and want to show a periodic trend. An example can be company sales over the last 20 years, daily transactional sales results for the year, interest rate evolution or the population growth from the year 1900, as I ...
Save A Chart Template Saving a Chart template in Excel is an efficient way to reuse your favourite or your company´s standard chart template. So whenever you have new data and want to create a chart with your (company´s) standard formatting, all you need is a couple of clicks and you will have it s...
In-Cell Bar Charts with the REPT Function When you are creating an Excel Dashboard and are limited by space and do not want to insert a chart, you can easily create an in-cell bar chart using the RPT (repeat) function. The RPT function uses the vertical bar character | as the first argument: text and references the va...
Logarithmic Scale In An Excel Chart When you have a large numerical range of data and you want to plot a graph, you will most probable end up with a skewed looking chart like the one below: You can use the logarithmic scale (log scale) in the Format Axis dialogue box to scale your chart by a base of 10. W...