# Add Another Series to Chart

After configuring a chart and testing it with a single data series, you can add **additional series** to the same chart to enable **comparative analysis**.

Before adding a new series, the chart type must be changed back from **Pie Chart** to **Line Chart**, as multiple series are supported on line‑based charts.

***

#### Change Chart Type Back to Line

To convert the chart from **Pie** back to **Line**, update the following configuration values:

* Update the **`DASHTYPE`** column in the **`DASH_WIDGET_PROP`** table to:

```
DASHTYPE = 'line'
```

* Update the **`CHART_TYPE`** column in the **`DASH_WIDGET_CHART_PROP`** table for the existing series to:

```
CHART_TYPE = 'line'
```

These changes ensure that both the chart and its data series are rendered using the Line chart format.

***

#### Add a New Chart Series

To add another series to the chart, insert a **new record** into the **`DASH_WIDGET_CHART_PROP`** table using the following values.

This new record defines a second series that will be displayed alongside the existing one.

***

#### New DASH\_WIDGET\_CHART\_PROP Record

| Column            | Value         |
| ----------------- | ------------- |
| ID                | `9010102`     |
| DASH\_ID          | `90101`       |
| CHART\_TYPE       | `line`        |
| TABLE\_NAME       | `MOCKUP_DATA` |
| FIELD\_NAME       | `COL2_VALUE`  |
| FIELD\_DESC       | `COL1_DESC`   |
| COND1\_FIELD      | `DASH_CODE`   |
| COND1\_VALUE      | `SA004-1`     |
| SEQ               | `2`           |
| NAME              | `CHAINGMAI`   |
| STACK\_GROUP      | *(empty)*     |
| COND2\_FIELD      | `COL2_DESC`   |
| COND2\_VALUE      | `CHAINGMAI`   |
| FIELD\_DESC\_SORT | *(empty)*     |
| FIELD\_PREFIX     | *(empty)*     |
| FIELD\_SUFFIX     | *(empty)*     |
| SYMBOL            | *(empty)*     |
| LEGEND            | *(empty)*     |
| FIELD\_COLOR      | *(empty)*     |
| DATA\_LABEL       | *(empty)*     |
| Y\_AXIS           | *(empty)*     |

***

#### Purpose of the New Series

This additional series:

* Uses the same dataset and chart configuration
* Filters data for **Chiang Mai**
* Adds a second line to the chart
* Enables **comparison between Bangkok and Chiang Mai across each quarter**

***

#### Verify the Updated Chart

After inserting the new series configuration:

1. Open the dashboard page again.
2. Click the **Training** menu (or the configured dashboard menu).

***

#### Expected Result

The chart now displays **two Line series**, comparing **Income between Bangkok and Chiang Mai** by quarter, as shown below.

<figure><img src="https://2015371994-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMpDjHWFRUtZ5nJcSfVXd%2Fuploads%2Fr8bDT9mtayrrjcdtcJuj%2Fimage.png?alt=media&#x26;token=2620cfcb-386d-4c74-9b8b-b10e22a668c7" alt=""><figcaption></figcaption></figure>

***

#### Summary

By adding another record to the `DASH_WIDGET_CHART_PROP` table:

* You can visualize multiple data series on a single chart
* Compare multiple dimensions or categories
* Extend chart insights without creating additional widgets

This demonstrates how the Widget Dashboard supports **multi‑series visualizations** using a flexible, configuration‑driven approach.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.onewebstack.com/building-apps/ui-page-designer/ux-ui-components/dashboard/widget-dashboard/steps-to-create-a-widget-dashboard/add-another-series-to-chart.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.