Jump to content
  • Gantt Chart Mod for Spotfire®

    Version 1.1.0, released November 2023



    The Gantt chart is a type of bar chart, that visualizes various categories into time series. Gantt charts illustrate the start and finish time in time period blocks.

    Gantt charts are often used in project management as one of the most popular and useful ways of showing activities displayed against time. On the left of the chart is a list of the activities and along the top is a suitable time scale. Each activity is represented by a bar; the position and length of the bar reflects the start date, duration and end date of the activity.

    Data requirement

    Every mod handles missing, corrupted and/or inconsistent data in different ways. It is advised to always review how the data is visualized.

    To make the Gantt chart work properly, the underlying data must be formatted in a certain way. A data table with at least three columns is required. At least one column must contain tasks names. A second column must contain start dates for each task. And a third column must contain end dates for each task.

    An optional column to show progress (%) may also be used.

    Setting up the chart

    In this example dataset, we have six columns: project, task, start, end, owner, completion

    step task from to owner completion
    Concept Groundwork 07/01/2021 07/05/2021 Cross teams 1.0
    Concept MVP definition 07/06/2021 07/06/2021 Product 1.0
    Concept Effort estimation 07/06/2021 07/09/2021 Cross teams 1.0
    Development Back-end 07/12/2021 07/21/2021 Feature 1.0
    Development Models training 07/19/2021 07/30/2021 Data science 1.0
    Development User experience 07/12/2021 07/16/2021 UX 1.0
    Development Front-end 07/19/2021 07/23/2021 Feature 1.0
    Development Technical preview 08/02/2021 08/04/2021 Feature 1.0
    Productization Code review 08/04/2021 08/06/2021 Feature 1.0
    Productization Testing 08/05/2021 08/06/2021 Test 1.0
    Productization Texts and documentation 08/02/2021 08/06/2021 Writers 1.0
    Productization Beta release 08/09/2021 08/10/2021 Feature 1.0
    Release Bug fixes 08/09/2021 08/13/2021 Feature 1.0
    Release Final build 08/16/2021 08/17/2021 Cross teams 0.75
    Release Deployment 08/18/2021 08/19/2021 DevOps 0.0

    A Gantt chart can be configured to show the evolution of this project by creating a Gantt chart with the following setting:

    • Task = 'step' and 'task'
    • Start = 'from' with (First) as aggregation method
    • End = 'to' with (first) as aggregation method

    Optionally we could also use colors to show task blocks by team and use the completion data to show progress. E.g:

    • Color By = 'owner
    • Progress = 'completion'

    The end result will look something like this:

    The chart above shows one period block by step and task colored by responsible teams.

    Configuring the chart

    The Gantt chart can be configured by setting one or multiple categories of tasks and sub-tasks. Start dates and end dates for each category must be set with aggregation type (First).

    Once the Gantt chart is configured and has data provided, you can also highlight overdue tasks or hide weekends. These settings are accessed by clicking on the list of tasks or on the header.

    Using the chart


    View mode

    Switch to show/hide months and days.

    Zoom to details

    Use the zoom slider to get a closer look at details in your visualization.


    Hover a task block to show a tooltip with its name, start date, end date and eventual progression.


    Click a task block to mark it in the Gantt chart and in all other visualizations that use the same marking. Click a parent task to mark all sub-tasks. Click an empty space in between task blocks to clear marking.

    Help and support

    This Mod for Spotfire® is not supported by Support.
    In the event of issues or to suggest features and enhancements, submit an issue in the Mod's GitHub repository

    For general questions about Mods, please post a question in the Forum for Extensions & Mods to make it visible and routed to the appropriate team(s) to respond.

    More information about Mods for Spotfire®

    User Feedback

    Recommended Comments

    There are no comments to display.

  • Create New...