Gantt Chart with Machine Status

Application Scenario

In manufacturing report management, you need to show the operation status of machines over a period of time, such as equipment in the semiconductor industry, and lathes in the parts industry.

The gantt chart can accurately show the state of a machine over time, as shown in the following figure.

Implementation Method

Keep the start and end points of the status of the same machine in different time periods consistent according to the machine category in the data source.

For example, the status of Machine A: In use (2020-05-23 00:00:00 - 2020-05-26 00:00:00), Idle (2020-05-26 00:00:00 - 2020-05-28 00:00:00).

Data Preparation

Create a built-in dataset File1, 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.

Note:

 Progress is set to 0 by default, and the labels are misplaced according to Progress. Set Progress to a true value (such as 1) to center the labels of the Gantt chart.

Style Design

1. Choose Style > Label, select Use Label, tick Series in Text, and set Position to Center, as shown in the following figure.

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

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

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

Note: 

1. If you set Time Scaling to Off, the drag slider in the lower right corner of the chart would be not available.

2. Initial Level determines the position of the slider, or the length of the graph, which can be set from 0 to 21. The length of the graph doubles with each level.

3. When new layers are added, the corresponding icons of scaling also need to be realigned.

4. When not specified, Initial Level is automatically calculated based on the series graph. Weekend Tip takes effect when the level reaches 7 and above.

5. When you set Weekend Tip to On, the gray background is added to the time period where the weekend is located.

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 Machine Status.cpt