官术网_书友最值得收藏!

Using a tree map

The tree map, also known as a heat map, visualizes values by dividing an area into a set of rectangles. The following screenshot shows an example of a tree map:

Using a tree map

As you can see, two variables are used in this chart: one variable expressed by the relative size of each rectangle and another one illustrated by the color intensity. Instead of using the tree map, you can also choose the scatter plot chart to display two variables in one chart.

Getting ready

For this recipe, we can reuse the file we created in the Using a scatter plot chart recipe.

How to do it...

  1. Drag a Tree Map component to the canvas.
  2. Enter a name for the chart.
  3. Bind the cell range A4 to C9 to the By Range field.
  4. Select Data in Columns.
  5. Select By Series and bind the Name field to cell A1:
    How to do it...
  6. Go to the Appearance tab and select the Series sub-tab.
  7. Select a very dark color as High Color and a very light color as Low Color:
    How to do it...
  8. Preview the dashboard to check the result:
    How to do it...

How it works...

The tree map arranges the rectangles from big to small. The Cat 5 data (most expensive houses) is presented on the far left-hand side, while Cat 1 (cheapest houses) is illustrated by the block on the lower right-hand side. This rectangle also has the lightest color, indicating the lowest Weeks until sale value. In the recipe, we changed the colors to a more extreme range so that the differences between the rectangles are clearer.

主站蜘蛛池模板: 嵩明县| 墨玉县| 聊城市| 东安县| 囊谦县| 桓台县| 曲靖市| 凤冈县| 神池县| 灵璧县| 津市市| 湘潭市| 临海市| 阳春市| 象州县| 资溪县| 鹤山市| 乌兰察布市| 林州市| 策勒县| 道孚县| 绥宁县| 修水县| 布尔津县| 洞口县| 运城市| 兴义市| 东明县| 晋城| 城固县| 闸北区| 蒙自县| 金平| 孟州市| 辉南县| 通榆县| 临武县| 晋城| 徐州市| 江达县| 襄樊市|