Successfully!

Error!

Gantt Chart with Relevancy Line

  • Last update:  2022-01-19
  • I. Overview

    1. Application scenarios

    Gantt chart can not only reflect the completion of plans and actual activities, but also express the sequence of tasks

    • FS: Task B cannot be started until task a is completed

    • SS: Task B cannot be started until task a starts

    • SF: Task B cannot be finished until task a is finished

    • FF: Task B can't finish until task a starts

    Taking the FS relationship as an example, the display effect is shown in the following figure:

    截屏2021-01-06 上午11.48.10.png


    2. Implementation ideas

    Two new data sources are created. Dataset 1 uses ID to mark each task, and dataset 2 uses ID to configure the association relationship and association type of tasks.

    When Binding chart data, configure task Association.

    II. Examples

    1. Data preparation

    1) Create a new built-in datasetFile1, as shown in the figure below:

    2) Create a new built-in dataset File2, as shown in the following figure:



    2. Insert chart

    Merge a range cell, right-click cell A1, and select Cell Element > Insert Chart > Gantt chart, as shown in the following figure:

    截屏2021-01-05 下午4.13.57.png


    3. Data binding

    Bind the chart data, as shown in the figure below:

    2.3.png


    4. Style design

    1) Select Style > Series to customize the series color, as shown in the following figure:

    2) Select Style > Project Axis to set the style of horizontal and vertical header, as shown in the following figure


    3) Select Style > Ttimeline to set the styles of the upper and lower header, as shown in the following figure:



    5. Effect preview

    Save the template and click Pagination Preview. The effect is as follows:

    截屏2021-01-06 上午11.48.10.png

    Mobile terminal:

    18.png

    III. Template download

    Completed template, see %fr_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Chart\Gantt\GanttChart_RelevancyLine.cpt

    Click to download the template:

    GanttChart_RelevancyLine.cpt

    Attachment List


    Theme: Chart
    • Helpful
    • Not helpful
    • Only read

    Doc Feedback