Gantt Chart with Association Lines

Application Scenario

In addition to representing the completion of planned and actual activities, the Gantt Chart can display the sequencing of tasks. Four correlations are available here:

FS: Task B will not begin until Task A has been completed.

SS: Task B will not begin until Task A has begun.

SF: Task B will not be completed until Task A has begun.

FF: Task B will not be completed until Task A has been completed.

Take FS as the example, as shown in the following figure.

Implementation Method

Create two new data sources, dataset 1 and dataset 2.  Mark each task with the id in dataset 1, and configure the association relationship of the task as well as the association type with the id in dataset 2.

Configure Task Association in data binding.

Data Preparation

1. Create a built-in dataset File 1, as shown in the following figure.

2. Create a built-in dataset File 2, as shown in the following figure.

Chart Insertion

Merge required cells, right-click the cell A1, choose Cell Element > Insert Chart > Gantt Chart, and click OK, as shown in the following figure.

Data Binding

Bind the data to the chart, as shown in the following figure.

Style Design

1. Choose Style > Series, and select Custom Combination as Color Scheme, as shown in the following figure.

2. Choose Style > Project Axis, and set Horizontal Header and Vertical Header respectively, as shown in the following figure.

3. Choose Style > Timeline, and set Upper Header and Lower Header respectively, as shown in the following figure.

Effect Display

PC 

Save the template, and click Pagination Preview. The following figure shows the effect.

Mobile Terminal

You can download the template Gantt Chart with Association Lines.cpt