Gantt Chart with Machine Status-FineReport Help Document

Last update： 2022-01-19

I. Overview

1. Application scenarios

In the report management of manufacturing industry, it is often necessary to show the operation status of machines in a period of time, such as semiconductor industry equipment, parts industry lathe, etc.

Gantt chart can accurately show the state of the machine in a period of time, and the effect is shown in the following figure:

截屏2021-01-06 下午1.58.15.png

2. Implementation ideas

According to the machine category, the data source keeps the start and end time of the same machine in different time periods consistent, for example:

Machine A status: In use (2020-05-23 00:00:00 ~ 2020-05-26 00:00:00), Not in use (2020-05-26 00:00:00 ~ 2020-05-28 00:00:00).

II. Examples

1. Data preparation

Create a new built-in dataset File1, as shown in the figure below:

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:

2.3.png

Note: when the progress is not set, the default value is 0, and the labels are aligned according to the progress. In this case, the display position of labels will be disordered. When the progress is set to the true value (such as 1), the labels of Gantt chart can be displayed in the middle.

4. Style design

1) Select Style>Label > Center, as shown in the figure below

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

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

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

Note 1: if you choose to turn offTime zoom here, the drag slider in the lower right corner of the chart cannot be used.

Note 2: the Initial level determines the position of the slider, that is, the length of the figure. A total of 0-21 levels are provided, and the figure length will be doubled with each magnification.

Note 3: after adding a new level, the corresponding zoom button also needs to be readjusted.

Note 4: if not specified, the initial level will be calculated automatically according to the series of graphics. When the zoom level reaches 7 or above, the weekend tips will take effect.

Note 5: when Weekend tips is on, gray background will be added in the time period of weekend.