TreeMap a new chart in Excel 2016

A square pie chart

The TreeMap is like a square pie chart, but it has the added ability to show a hierarchy.

The data we will use is shown below. We have states broken down by segments, each with a value. Four segments for each state.

A Pie chart won’t work in this instance.

The TreeMap chart will show the values as squares or rectangles. The size of the rectangle represents the size of the value. See example below.

I have changed some of the default settings to arrive at the chart above.

I have deleted the legend and I have added the Banner option for the Data Series – see image below.

The overlapping option doesn’t always work as planned.

Also note that the banner is grey when it is initially installed. You need to select each major category and then update the fill colour to ensure the banner is the same colour as the category.

I have also added the values to the labels – as per image below.

How To Read the Chart

The chart is meant to be read from left to right.

NSW (1) is the largest state by total amount and is on the left. WA (2) is in the middle and QLD (3) on the right with the smallest total amount.

Within each coloured section the top left is the highest value – Cash in NSW, Wholesale in WA and Cash in QLD.

Within each colour as the values move to the left they decrease.

The values also decrease when they are displayed below. The rankings are showed in the image below. Bottom right is always the lowest value within each colour.

Unfortunately there are aren’t any options to move the labels.

As well as the layout at the top of this post the TreeMap chart will also work with the layout shown below.


Please note: I reserve the right to delete comments that are offensive or off-topic.