Gantt Chart with Machine Status

  • Last update:February 06, 2025
  • Overview

    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.

    机器1.png 

    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).

    Example

    Data Preparation

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

     机器2.png

    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.

     机器3.png

    Data Binding

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

     机器补充.png

    iconNote:

     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.

     机器6.png

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

     机器7.png

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

     机器8.png

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

     机器9.png

    iconNote: 

    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.

     机器1.png

    Mobile Terminal

     机器10.jpg

    Template Download

    You can download the template Gantt Chart with Machine Status.cpt


    Attachment List


    Theme: Chart
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy