# Creating multiple lines on a single chart

**URL:** <https://forum.inductiveautomation.com/t/creating-multiple-lines-on-a-single-chart/84984>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [January 30, 2024, 10:56pm UTC](https://forum.inductiveautomation.com/t/creating-multiple-lines-on-a-single-chart/84984 "2024-01-30T22:56:59Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sibusiso\_Moyo](https://avatars.discourse-cdn.com/v4/letter/s/f08c70/32.png) [@Sibusiso\_Moyo](https://forum.inductiveautomation.com/u/Sibusiso_Moyo)\
**Post date:** [January 30, 2024, 10:56pm UTC](https://forum.inductiveautomation.com/t/creating-multiple-lines-on-a-single-chart/84984/1 "2024-01-30T22:56:59Z")

</div>

I have a dataset with a date, a categorical field with 3 levels and time spent doing an activity. I would like to plot three lines, once for each category in one chart. Any suggestions how to do this in ignition designer perspective? I have tried XY chart and time series charts and didn't go too far.

Ideas are appreciated. My dataset looks like this:  
 ![multiple line plot](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/6/36b6ec4028ff656b2d9728b491cdd35e44897379.png)

I'd like my output to look like this:

 ![multiple lines out](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/e/dea08ea8702484cdc51649f609347a5cddeb3c80.png)

Thanks in advance!!

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [January 30, 2024, 11:19pm UTC](https://forum.inductiveautomation.com/t/creating-multiple-lines-on-a-single-chart/84984/2 "2024-01-30T23:19:50Z")

</div>

You can do this by creating a data source and series for each category.

---

<div class="post-metadata">

**Author:** ![Sibusiso\_Moyo](https://avatars.discourse-cdn.com/v4/letter/s/f08c70/32.png) [@Sibusiso\_Moyo](https://forum.inductiveautomation.com/u/Sibusiso_Moyo)\
**Post date:** [January 30, 2024, 11:23pm UTC](https://forum.inductiveautomation.com/t/creating-multiple-lines-on-a-single-chart/84984/3 "2024-01-30T23:23:13Z")

</div>

You mean use query binding three times in this case? A query for each series?

Thanks for your response.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [January 30, 2024, 11:24pm UTC](https://forum.inductiveautomation.com/t/creating-multiple-lines-on-a-single-chart/84984/4 "2024-01-30T23:24:13Z")

</div>

That would be the simplest - although it might not be the fastest.

---

<div class="post-metadata">

**Author:** ![Sibusiso\_Moyo](https://avatars.discourse-cdn.com/v4/letter/s/f08c70/32.png) [@Sibusiso\_Moyo](https://forum.inductiveautomation.com/u/Sibusiso_Moyo)\
**Post date:** [January 30, 2024, 11:25pm UTC](https://forum.inductiveautomation.com/t/creating-multiple-lines-on-a-single-chart/84984/5 "2024-01-30T23:25:08Z")

</div>

What's a better/faster solution?

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [January 30, 2024, 11:31pm UTC](https://forum.inductiveautomation.com/t/creating-multiple-lines-on-a-single-chart/84984/6 "2024-01-30T23:31:14Z")

</div>

I imagine you could create a custom property with the query you have now, then use expression bindings on your individual data sources with Phil's [Integration ToolKit Module](https://forum.inductiveautomation.com/t/automation-professionals-integration-toolkit-module/74934). Though depending on your data it may plenty performant with individual queries.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [January 30, 2024, 11:50pm UTC](https://forum.inductiveautomation.com/t/creating-multiple-lines-on-a-single-chart/84984/7 "2024-01-30T23:50:13Z")

</div>

> [@Sibusiso\_Moyo](#):
>
> What's a better/faster solution?

Write one complex SQL query to return all the data in one trip versus writing three simple and easy to debug and maintain queries.