Successfully!

Error!

Multi-layer Pie Chart

  • Last update:  2021-02-02
  • I. General

    1) The Multilayer Pie Chart, based on pie charts, introduces the concept of levels. There is an inclusion relationship between different levels. You can click to view the data of different levels. The Multilayer Pie Chart is suitable for displaying data of a hierarchical structure, such as regional data, company hierarchy and so on.

    2) The Multilayer Pie Charts has an advantage that it can visualize the proportion of each part in the whole and support the data drilling. It is not suitable for displaying too many categories, and allows no negative values in Data. Any negative value that appears will be deemed as positive numbers for aggregation.

    3) Please read: Chart Data, Chart Style, Chart Special Effect

    You will learn
    • Steps

      • Prepare Data

      • Insert chart

      • Bind Data

      • Set style

      • Set Special Effect

      • Preview Effect

    II. Steps

    1. Prepare Data

    1) Create new Normal Report and new datasets ds1.

    2) Use the default data to connect FRDemoEN.

    3) Input the following data query statement ds1:

    SELECT * FROM ORDERS LIMIT 50

    1.png 

     

    2. Insert chart

    1) Take Floating Chart as an example: Refer to Insert Floating Chart:

    • Select [Multilayer Pie Chart] on the left [Chart Type].

    • Select [Multilayer Pie Chart].

    • Click [OK] to complete the insertion of the multilayer pie chart.


    3. Bind Data

    1) The Multilayer Pie Chart can be set as follows:

    • Double click the Multilayer Pie Chart.

    • Click [Cell Element] on the right-hand pane. Click [Data].

    • Select [Dataset data] in [Data source], and [ds1] in [Dataset]

    2) The special configuration for the data binding are as follows:

    • Index name: This text message will prompt when the mouse hovers over one sector of the pie chart if you check the Index Name in [Style]>[Chart Prompts].

    • Level Number: It is set as 3 by default, and determines the number of levels below.

    • Level 1: You can select the Category of the Dataset corresponding to the innermost level. The default setting is SHIPPORT.

    • Level 2: You can select the Category of the Dataset corresponding to the second level. The default setting is SHIPMETHOND.

    • Level 3: You can select the Category of the Dataset corresponding to the third level. The default setting is AMOUNT.

    • Value: The value corresponding to each sector affects the sector size. We set it to PAID.

    • 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].

      • Modify the title of the Multilayer Pie Chart by setting [Text] to:  Multilayer Pie Chart.

    • Set label

      • Select [Label].

      • Check [Use Label]

      • Select [Level Name] in [Content].

      • Click [Layout]-[Position], and select [Outside Pie] and [Traction Line]

    Note: The Traction Line setting/label of the Multilayer Pie Chart is displayed externally and only takes effect for the outermost level. The internal Level Label is forced to be displayed internally.

      

    2) Special Style

    Some settings in the [Style]>[Series] of the Multilayer Pie Chart are different from the general style, and are introduced separately here. The effect of the settings can be previewed on a real time basis in the left pane:

    • Gradual Level: It controls the color gradient of the levels. You can choose Gradient Light or Gradient Deep here. The default setting is Gradient Light.

    • Start Angle: The Start Angle of the pie chart can be any integer between 0 and 360, and is set as 0 by default.

    • End Angle: The End Angle of the pie chart can be any integer between 0 and 360, and is set as 360 by default.

    • Inner Radius: The percentage of the inner diameter of the blank area inside the pie chart can be set here, and is set to 0 by default (solid pie chart).

    • Drill: You can set whether the Multilayer Pie Chart can support the drilling here. This field is set as “On” by default.

    • Rotatable: You can set whether the Multilayer Pie Chart can support the rotation here. This field is set as “On” by default.

    Note:

    • When setting the inner diameter, the overall radius, after deducted the inner diameter, is equally divided among all levels.

    • After the setting of drill, the radius of the pie chart in the center must take account for 50% of the overall radius no matter whether the inner radius has been set, and the rest of the overall radius is equally divided among the remaining levels.

     

     

    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. Below is an example of a Multilayer Pie Chart whose Style has been set. You can click the level of the Multilayer Pie Chart to drill the detailed data at that level, and click on the white circle in the center to return to the previous level.

     

     

    Attachment List


    Theme: Chart
    • Helpful
    • Not helpful
    • Only read

    Doc Feedback