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

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.

主站蜘蛛池模板: 孝义市| 沐川县| 巨鹿县| 浮梁县| 巩义市| 城口县| 措勤县| 平罗县| 于田县| 民丰县| 林芝县| 平邑县| 济源市| 洪湖市| 原平市| 兰西县| 宁海县| 乌审旗| 科尔| 湘潭县| 包头市| 靖西县| 安平县| 海口市| 樟树市| 奎屯市| 定陶县| 邵东县| 华坪县| 辽阳市| 错那县| 高要市| 司法| 宁德市| 青铜峡市| 顺义区| 藁城市| 涡阳县| 海南省| 南岸区| 环江|