Gantt Chart with Association Lines

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:

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.

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:

3. Data binding

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

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:

Mobile terminal:

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