416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
Dashboard v5.0

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

How to create a Gantt Chart

Hide navigation
RSS
Modified on Fri, 09 May 2014 04:30 PM Categorized as Chart, Data Controls, Datasets

Overview

A Gantt chart is a type of bar chart that displays a project schedule. It shows the start and finish dates of the work breakdown structure of the project. Gantt charts are used for scheduling resources in project management, production processes, employee scheduling etc.

Dundas Dashboard does not offer Gantt as chart type but it's easy to create a Gantt chart using a range bar chart type where bars represent the beginning and end of tasks or tasks along a time axis.

This article show how to create a simple Gantt Chart.

Steps

Set up the Virtual Table

Set up a manual virtual table using the SQL Query below that shows a schedule of five tasks each with a start and an end date:

SELECT 1 Task Number, 'Task 1' Task Name, Convert(datetime,'01/01/2014')Start Date, Convert(datetime,'03/01/2014')End Date UNION ALL SELECT 2 Task Number, 'Task 2' Task Name, Convert(datetime,'03/01/2014')Start Date, Convert(datetime,'06/01/2014')EndDate UNION ALL SELECT 3 Task Number, 'Task 3' Task Name, Convert(datetime,'02/01/2014')Start Date, Convert(datetime,'05/01/2014')End Date UNION ALL SELECT 4 Task Number, 'Task 4' Task Name, Convert(datetime,'01/01/2014')Start Date, Convert(datetime,'07/01/2014')End Date UNION ALL SELECT 5 Task Number, 'Task 5' Task Name, Convert(datetime,'05/01/2014')Start Date, Convert(datetime,'07/01/2014')End Date

Virtual Table

Virtual Table


Create the KPI/Dataset

From the virtual table, create a KPI/Dataset. Add a calculated column using the expression below that shows the task duration. This is optional and is only needed if the duration is to be used or shown on the dashboard:

DATEDIFF(day, {Start Date} , {End Date})

KPI/Dataset

KPI/Dataset



Create the chart

Create a new dashboard and drag the Range Bar Chart control from the toolbox onto the dashboard canvas. Drop the KPI/Dataset on the control and set its X-Axis, Bar Start and Bar End as shows:

Set the dimensions

Set the dimensions



Result

Once you complete the setup, preview the dashboard. This should be the result:

Gantt chart

Gantt chart



The task duration calculated on the KPI/Dataset can also be displayed beside the bars. To do this, open the Series property of the chart and set the Label Text to the Task Duration column as shown below:

Label Text

Label Text



Once the label is set, this will be the result:

Gantt Chart showing the task duration

Gantt Chart showing the task duration



All the existing chart properties can be used and additional complexity can be achieved through a combination of the existing properties and scripting.

Related Topics

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2014 Dundas Data Visualization, Inc.