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

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.

主站蜘蛛池模板: 重庆市| 嘉鱼县| 于都县| 密云县| 昔阳县| 奇台县| 水富县| 海丰县| 东海县| 牡丹江市| 沿河| 平度市| 铁岭市| 中宁县| 平南县| 漠河县| 凯里市| 平顶山市| 铜鼓县| 于田县| 溆浦县| 灯塔市| 郯城县| 旬阳县| 漾濞| 天台县| 龙井市| 孝感市| 柯坪县| 长春市| 杭州市| 柘荣县| 邵阳县| 三门峡市| 天台县| 嘉义市| 靖远县| 平度市| 曲沃县| 寿阳县| 犍为县|