---
title: Creating Charts for Reporting
slug: singleconnect-reference-guide-3-1-0/creating-charts-for-reporting
description: Learn how to add and adjust charts in Single Connect's Reporting section. Run queries from the SQL editor, save and visualize results with various visualization types, and make custom adjustments to chart properties. Save, overwrite, or create new charts,
docTags: 
createdAt: 2022-08-02T18:25:44.000Z
---

Any chart can be added and adjusted from the Reporting section of Single Connect:

1. Navigate to **Dashboard **> **Reports** > **SQL Lab**.
2. Once the database has been selected, the user can run any desired query from the SQL editor, and then save or visualize it. Saved queries can be accessed from the Saved Queries section under the SQL Lab.

Once the user runs the query, the results collected from the database are shown on the Results section, as illustrated in the figure below.

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/cq4X8Yasmn5QDt2WW6IKi_running-queries-from-sql-editor-to-create-a-chart.png "Running queries from SQL Editor to Create a Chart")

Once the user clicks on the **Visualize** button, it is possible to select different visualization types from the** Chart Type** section, as well as the parameters that user needs to add or remove. 

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/vsddIRQ4e7j68JeyCP6YX_user-selects-chart-type-and-columns-to-create-a-chart-adjusting-chart-properties.png "User selects Chart Type and Columns to Create a Chart")

**Example:**


Since select \* from t\_device query has been executed and the **Table View **visualization type has been selected, Superset will show results of the selected columns in Table view. Also, the time filter can be edited, and columns can still be adjusted from the **Group By** section. The User can edit the chart name as well. 


![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/mMchPzW2A-fStVYoXnH2I_image.png "Adjusting Chart Properties")

The result might change, depending on the time filter, and selected columns & functions in the Group By section. Once the user makes adjustments , he/she needs to run the query again from the **Run Query** section to see the updated result.
When adjustments are ready, and once the user clicks the** Save** button, a pop-up window providing the following options will open:

-
  Overwrite chart
-
  Save as a new chart
-
  Link created chart to dashboard

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/CqF0zJHWtU0stZ9Y0YLB6_overwrite-or-save-new-chart-and-link-to-dashboard.png "Overwrite or Save New Chart and Link to Dashboard")

After saving, the desired chart can be found under the Chart section of the Reporting tab.

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/l6PHYL00uKlx2XoRcMoYU_created-charts-in-the-reporting-section-charts-tab-.png "Created Charts in the Reporting section “Charts” tab ")