Gantt Chart

Application Scenario

Gantt charts (also called bar charts) are commonly used in project management to display the inherent relationship between projects, progress, and other time-related system advancements over time in the form of bar charts.

Implementation Method

FineBI does not provide Gantt charts now. You can use custom chart's rectangular blocks to achieve the effect.

Data Preparation

1. Choose My Analysis > New Subject.

2. Upload the sample data by choosing + > Local Excel > Upload Data > OK.

Sample data: Gantt Chart.xls

Start Position and Length Obtaining

Two important indicators for implementing the Gantt chart effect through rectangular blocks include the task start time (determining the rectangular block's start position) and the task duration (determining the rectangular block's length).

1. Click Formula Column, name the added column, enter the function DATESUBDATE(${Start Time},"2015-02-08","d"), and click OK. Then the starting position of each rectangle block is obtained by calculating the time interval between 2015-02-08 and the start time of each task, as shown in the following figure.

The datesubdate function is used to calculate the interval between two dates. For details, see DATESUBDATE.

2. Add another column to calculate the task duration.

3. Click Save and Update.

Component Creation

1. Click the Add Component icon, drag fields, select Custom Chart in Chart Type, and select Rectangular Block from the drop-down list in Graphic Property.

2. Drag fields into each label column in Graphic Property, as shown in the following figure.

You can display the duration through the rectangular block's length by dragging the Duration field into the Size column.

Component Beautifying

Effect Display

The effect is shown in section "Application Scenario."