# XY chart target line

**URL:** <https://forum.inductiveautomation.com/t/xy-chart-target-line/72283>\
**Category:** Ignition\
**Created:** [April 11, 2023, 3:53am UTC](https://forum.inductiveautomation.com/t/xy-chart-target-line/72283 "2023-04-11T03:53:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ABIJITH\_MURALI](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@ABIJITH\_MURALI](https://forum.inductiveautomation.com/u/ABIJITH_MURALI)\
**Post date:** [April 11, 2023, 3:53am UTC](https://forum.inductiveautomation.com/t/xy-chart-target-line/72283/1 "2023-04-11T03:53:37Z")

</div>

Using XY chart I plotted compressors daily energy consumption and I need to place a target line in the graph.  
The graph uses column render property to plot the data and my dataset contain t\_stamp and energy (kWh/day).

---

<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:** [April 11, 2023, 8:48am UTC](https://forum.inductiveautomation.com/t/xy-chart-target-line/72283/2 "2023-04-11T08:48:16Z")

</div>

Add the target into your SQL query.

```auto
SELECT t_stamp, kWh, 2200 AS Target
FROM ...

```

or add a Script Transform on your existing query binding and add in the required column.

---

<div class="post-metadata">

**Author:** ![ABIJITH\_MURALI](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@ABIJITH\_MURALI](https://forum.inductiveautomation.com/u/ABIJITH_MURALI)\
**Post date:** [April 12, 2023, 3:26am UTC](https://forum.inductiveautomation.com/t/xy-chart-target-line/72283/3 "2023-04-12T03:26:56Z")

</div>

Thanks

---

<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:** [April 12, 2023, 7:13am UTC](https://forum.inductiveautomation.com/t/xy-chart-target-line/72283/4 "2023-04-12T07:13:08Z")

</div>

You're welcome. Don't forget to click the "Solution" button to mark the thread as being solved.