# Create a chart

Click ![](https://1648695648-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FygZlXb1uCVgursV03Kgn%2Fuploads%2FJSohFCPIBsluI5WARYdN%2Fimage.png?alt=media\&token=2abdc9af-438a-409e-b95c-6cd609088e96)icon in the left menu bar and choose your desired chart you want to create

Click to add the chart on the canvas

On the right panel, choose connection and choose your created query

Move to the Data tab, you can see the available fields, which are from your created query

Drag and drop columns in availables field to create your Chart

Finalize the charts by adding title, choosing colors and style the graph

<figure><img src="https://1648695648-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FygZlXb1uCVgursV03Kgn%2Fuploads%2FsL3KXWbYMnV9D1KV05Ls%2Fadd-a-chart.gif?alt=media&#x26;token=8c479465-066c-4aee-9b12-3c75c4ec9023" alt=""><figcaption></figcaption></figure>

**If you haven't written your query before you add a chart, you can add a query and chart simultaneously**

Click ![](https://1648695648-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FygZlXb1uCVgursV03Kgn%2Fuploads%2FJSohFCPIBsluI5WARYdN%2Fimage.png?alt=media\&token=2abdc9af-438a-409e-b95c-6cd609088e96)icon in the left menu bar and choose your desired chart you want to create

Click to add the chart on the canvas

On the right panel, choose connection and write SQL on the query box, you can view the Schema and Table&#x20;

Name your query after writing

Choose Cache time and Tags if you want

Move to the Data tab, you can see the available fields, which are from your created query

Drag and drop columns in availables field to create your Chart

Finalize the charts by adding title, choosing colors and style the graph

<figure><img src="https://1648695648-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FygZlXb1uCVgursV03Kgn%2Fuploads%2FoFJpd6VwSpiKFxlAWejV%2Fadd-a-chart-2.gif?alt=media&#x26;token=2d936677-9d83-4475-8fec-4f04efa472c5" alt=""><figcaption></figcaption></figure>
