# Multiple Lines on Chart Graphics

**URL:** <https://forum.inductiveautomation.com/t/multiple-lines-on-chart-graphics/9058>\
**Category:** Ignition\
**Created:** [September 15, 2014, 5:47pm UTC](https://forum.inductiveautomation.com/t/multiple-lines-on-chart-graphics/9058 "2014-09-15T17:47:13Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![damon](https://avatars.discourse-cdn.com/v4/letter/d/e47c2d/32.png) [@damon](https://forum.inductiveautomation.com/u/damon)\
**Post date:** [September 15, 2014, 5:47pm UTC](https://forum.inductiveautomation.com/t/multiple-lines-on-chart-graphics/9058/1 "2014-09-15T17:47:13Z")

</div>

I am having trouble working with the Ignition Chart. I have posted a video on youtube just to show you what issue I am having: [youtube.com/watch?v=8GxlugF … e=youtu.be](https://www.youtube.com/watch?v=8GxlugFs0kU&feature=youtu.be)

As you can see I am trying to plot a trend graph with the chart object. There should only be two continuous lines, but there are multiple streaks as the graph updates itself. I can’t seem to fix this problem.

The data is from the Ignition Historian that is reading OPC tags and storing them to a database. The chart then reads the database data based off a SQL Query that is updated based on the stated conditions.

I think the problem is that I am updating the Chart’s SQL Query data set too quickly and it is plotting over and over again?

Let me know if there is a way to fix this issue with the charts. The current version of my ignition platform is 7.6.6 and it is running on windows 7 32 bit.

Thanks!

Damon

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a0cefb64bce974de7045449a021e8f04ca93ee34.png)  
  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c63f9c3abcabb1ac2b8ec481eba1e4231bceba2e.png)  
  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/552608998c69d4099410acdfd153a840e7c06ede.png)

---

<div class="post-metadata">

**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\
**Post date:** [September 15, 2014, 8:23pm UTC](https://forum.inductiveautomation.com/t/multiple-lines-on-chart-graphics/9058/2 "2014-09-15T20:23:30Z")

</div>

Replace sim\_time with t\_stamp in the query or add t\_stamp as the first column

Add “ORDER BY t\_stamp”

---

<div class="post-metadata">

**Author:** ![damon](https://avatars.discourse-cdn.com/v4/letter/d/e47c2d/32.png) [@damon](https://forum.inductiveautomation.com/u/damon)\
**Post date:** [September 16, 2014, 4:19pm UTC](https://forum.inductiveautomation.com/t/multiple-lines-on-chart-graphics/9058/3 "2014-09-16T16:19:07Z")

</div>

The purpose of the graph is to plot data against the simulated time (sim\_time).

I still don’t understand why are they mutliple lines that make up one trend line on the graph or how to fix it…

Anyone have any other suggestions?

---

<div class="post-metadata">

**Author:** ![Chris\_Taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/chris_taylor/32/3315_2.png) [@Chris\_Taylor](https://forum.inductiveautomation.com/u/Chris_Taylor)\
**Post date:** [September 16, 2014, 4:33pm UTC](https://forum.inductiveautomation.com/t/multiple-lines-on-chart-graphics/9058/4 "2014-09-16T16:33:23Z")

</div>

damon

Can you show us the graph

---

<div class="post-metadata">

**Author:** ![damon](https://avatars.discourse-cdn.com/v4/letter/d/e47c2d/32.png) [@damon](https://forum.inductiveautomation.com/u/damon)\
**Post date:** [September 16, 2014, 4:58pm UTC](https://forum.inductiveautomation.com/t/multiple-lines-on-chart-graphics/9058/5 "2014-09-16T16:58:43Z")

</div>

Did the youtube link work in the first post?

[youtube.com/watch?v=8GxlugF … e=youtu.be](https://www.youtube.com/watch?v=8GxlugFs0kU&feature=youtu.be)

let me know if it doesn’t work.

---

<div class="post-metadata">

**Author:** ![damon](https://avatars.discourse-cdn.com/v4/letter/d/e47c2d/32.png) [@damon](https://forum.inductiveautomation.com/u/damon)\
**Post date:** [September 16, 2014, 10:37pm UTC](https://forum.inductiveautomation.com/t/multiple-lines-on-chart-graphics/9058/6 "2014-09-16T22:37:16Z")

</div>

It seems like a recreation of the historian/database made it work again…  
I guess problem solved!

---

<div class="post-metadata">

**Author:** ![Chris\_Taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/chris_taylor/32/3315_2.png) [@Chris\_Taylor](https://forum.inductiveautomation.com/u/Chris_Taylor)\
**Post date:** [September 17, 2014, 8:55am UTC](https://forum.inductiveautomation.com/t/multiple-lines-on-chart-graphics/9058/7 "2014-09-17T08:55:39Z")

</div>

Ah sorry damon, I didn’t see the link, looks funky, glad its sorted.