Treemap chart
A treemap chart is a hierarchical chart that is relatively new in Excel. It can be used in place of a clustered column chart for just one set of values for a metric. It always arranges the category values in descending order. It also has the advantage of being space-optimal, adjusting very well to size changes. The following screenshot is an example of a treemap showing regional sales:
Figure 8.35 – Treemap chart of regional sales
Notice that the arrangement of the category values in the chart is in descending order and not in their natural order in the source table. That can be useful in a dashboard of changing data values, as it will always rearrange the category values in descending order.
Lastly, if we reduced the width of the chart, it would reshape its entire plot to make good use of the new size dimensions assigned to it. See the following screenshot for this size adjustment:
Figure 8.36 –...
