With this tutorial you will learn to create a Gantt chart from the structure of your table in the database to generate the chart itself. In this tutorial we will use a MYSQL database for table creation.

1. With the SQL command below will create the table and the fields used in the construction of the Gantt Chart. The script below is a table built from the SQL Builder option, which is found in the option (**Database -> SQL Builder**) in the top horizontal menu of ScriptCase.

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0a12g7ff922ba952c412ab31f3c666e9066da)

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0a12g0c8662e167a541568778079bc4d447a7)

2. To create a Gantt Chart is required consultation application (grid). Create an application grid and enable in Toolbar option and insert the Gantt.

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0a12g558b5173c746430c900b890c10cae491)![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0a12g26c2d02835e84ba3ac7014c8129f120a)

3. Next, we must define the graph fields on Gantt settings.

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0a12gcc01992f386e4ff3826a710157bfd86f)

4. We must associate the fields of the table with the graph, for the display correction of the information:

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0a12gea13de8d8951461bbcf3af8654d48f13)

5. To display the chart, you should run the query application and click the chart button:

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0nzsq55541dd0b32c4b629ce91806cafd9a27)

6.The graphic will be displayed in a new tab. This is an example of displaying using HTML 5.

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0nzsq54fad641535a4431837ff980bc86b536)