# Timeseries line chart with bullets

**URL:** <https://forum.inductiveautomation.com/t/timeseries-line-chart-with-bullets/75977>\
**Category:** Ignition\
**Created:** [July 6, 2023, 4:18am UTC](https://forum.inductiveautomation.com/t/timeseries-line-chart-with-bullets/75977 "2023-07-06T04:18:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![chaoliang](https://avatars.discourse-cdn.com/v4/letter/c/ba8739/32.png) [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\
**Post date:** [July 6, 2023, 4:18am UTC](https://forum.inductiveautomation.com/t/timeseries-line-chart-with-bullets/75977/1 "2023-07-06T04:18:12Z")

</div>

Hi just to see whether the timeseries chart can add bullets to the line, like the XY chart below.

For example, I have a 1 hour data of 5 second sampling rate, but I want to add bullet to the value at each minute, so there will be only 60 bullets showing on the trend, instead of 720 bullets.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/5/15001e4982a06aa0b0c28ae836a3d26d9f268281.png)

---

<div class="post-metadata">

**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\
**Post date:** [July 6, 2023, 3:39pm UTC](https://forum.inductiveautomation.com/t/timeseries-line-chart-with-bullets/75977/2 "2023-07-06T15:39:24Z")

</div>

Line chart with categorical X axis! My CDO!

---

<div class="post-metadata">

**Author:** ![chaoliang](https://avatars.discourse-cdn.com/v4/letter/c/ba8739/32.png) [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\
**Post date:** [July 7, 2023, 1:59am UTC](https://forum.inductiveautomation.com/t/timeseries-line-chart-with-bullets/75977/3 "2023-07-07T01:59:45Z")

</div>

Can you elaborate how it can be done in timeseries chart?

I have managed to create on in XY Chart, but it looks strange and there's no easy setting to create horizontal line to indicate the alarm limits, unless I add in another dataset to log the alarm limit and indicate it in it, which is waste of memory.

The time series chart is great. The only thing I cannot achieve in time series chart is the bullets.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/5/e549d05b223298939d705a366cf898ab3d7047ad.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/2/a2db501f55032d3853ce012f0aec969e739994a3.png)

---

<div class="post-metadata">

**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\
**Post date:** [July 7, 2023, 2:26pm UTC](https://forum.inductiveautomation.com/t/timeseries-line-chart-with-bullets/75977/4 "2023-07-07T14:26:19Z")

</div>

I use the XY with the additional dataset for lines.

I use queries for the data.

In MSSQL, I use case with preceding to evaluate values where I am missing data sometimes.

I join in the outermost with a dataset that I know has all the data points, or construct one to join with.  
I do that so that I always have a value for X,Y at the same pace so my graph doesn't mess up.

I think that I used invisible bullets with tooltips to make some tooltips show, might be useful later.  
Sometimes I add another dataset to show values on the table constantly via bullets as well.

[Anatomy of an XY Chart – amCharts 4 Documentation](https://www.amcharts.com/docs/v4/chart-types/xy-chart/)]  
This will help you too, as the XY chart is kind of built on it.
