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

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.

主站蜘蛛池模板: 莱芜市| 龙岩市| 泰来县| 淳安县| 科技| 蕲春县| 开江县| 迁西县| 舒兰市| 云和县| 禹州市| 日照市| 安溪县| 阜新市| 金湖县| 广德县| 芜湖县| 新巴尔虎左旗| 望江县| 沙河市| 弥勒县| 清新县| 娄烦县| 香格里拉县| 永川市| 武强县| 东阿县| 肃北| 开封县| 定西市| 双鸭山市| 松潘县| 杭锦后旗| 太原市| 鱼台县| 荣昌县| 鹿泉市| 诸城市| 武功县| 唐山市| 南投县|