I. General
1) Rectangular Tree Charts are used to depict the percentage of data with hierarchy, and can be drilled down to show data in the next level. Starting from the root node, the space is divided into rectangles according to the corresponding number of child nodes, and the area of the rectangles corresponds to the attributes of corresponding child nodes. Each rectangle is in turn recursively segmented till the root node according to the child nodes of corresponding root.
2) Rectangular Tree Charts are suitable for presenting data with hierarchy and can visualize comparisons between data at the same level. The advantage is that they are more compact and can show more information, including the weight of each node, than other charts with the same size of canvas do. The disadvantage is that they are not intuitive and clear enough, and the percentages of data are too small to be easily observed.
3) Please read: Chart Data, Chart Style and Chart Special Effects
| You will learn |
|---|
|
II. Steps
1. Prepare Data
1) Create a File Dataset named iPhone and select the Excel file, as shown below:
2) Preview data:
2. Insert chart
1) Take Floating Chart as an example: Refer to Insert Floating Chart:
In the pop-up [Chart Type] panel, select [Rectangular Tree] on the left.
Select [Rectangular Tree]
Click [OK] to finish inserting the Rectangular Tree Chart.
3. Bind Data
1) Set data as follows:
Select Rectangular Tree.
Click [Cell Element] on the right-hand pane. Click [Data].
Select [Dataset data] in [Data source], and [iphone] in [Dataset].
2) The special configuration for the data binding are as follows:
Index name: If the Index Name under [Style]>[Tooltip] is checked, then the system will prompt the Index Name when the mouse hovers over the rectangle. We set it to Ratio.
Level Number: You can set the Level Number for the Rectangular Tree Chart. Such number is 3 by default, and can only be a number between 1-15. The specific Level Number corresponds to the [Level] option. You can set the Level Number to 2.
Level: The number of Level depends on Level Number. You can set [Level1] to: time and [Level2] to: type.
Value: The value corresponding to each rectangular block affects the size of the rectangle. We set it to ratio
Summary Method: It can be set to None, Sum, Average, Maximum, Minimum or Count, and is set to None by default.
4. Set style
1) General style
Select the chart and click [Style]. There are a variety of chart types, but most of the style settings are similar to the general style. You can refer to Chart Style and the default setting is as follows:
Change the chart title:
Click [Title].
Change the [Text] of the Title to: Rectangular Tree.
Add Label
Click on the [Label]. Check [Use Label].
Select [Level Name] and [Value] in [Content].
Select [Up] in [Layout]-[Position].
Note: When Use Label is activated, if the rectangle in which the label is located is too small, then the label will not be displayed.
5. Set Special Effect
For a detailed description of settings of Special Effect, see Chart Special Effects for the settings of general special effects.
6. Preview Effect
Save and preview. An example of a Rectangular Tree Chart with the Style already set is shown below.
Previous：Map drilling with custom image
