Creating a Treemap

Treemaps are useful for representing hierarchical (tree-structured) data as a part-to-whole relationship. It shows data as a set of nested rectangles, and each branch of the tree is given a rectangle, which represents the amount of data it comprises. These can then be further divided into smaller rectangles that represent subbranches, based on its proportion to the whole.

We can show information via the color and size of the rectangles and find out patterns that would be difficult to spot in other ways. They make efficient use of the space and hence can display a lot of items in a single visualization simultaneously.

Getting ready

We will create a Treemap to show the sales and profit across various product subcategories. Let's see how to create a Treemap.

How to do it…

1. We will first create a new sheet and rename it as Treemap.

2. Next, we will drag Sales from the Measures pane and drop it into the Size shelf.

3. We will then drag Profit from Measures pane and drop it into the Color...