# Distribution Curve on Chart

**URL:** <https://forum.inductiveautomation.com/t/distribution-curve-on-chart/68338>\
**Category:** Ignition\
**Created:** [January 6, 2023, 10:54pm UTC](https://forum.inductiveautomation.com/t/distribution-curve-on-chart/68338 "2023-01-06T22:54:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aaron\_Shivne](https://avatars.discourse-cdn.com/v4/letter/a/a8b319/32.png) [@Aaron\_Shivne](https://forum.inductiveautomation.com/u/Aaron_Shivne)\
**Post date:** [January 6, 2023, 10:54pm UTC](https://forum.inductiveautomation.com/t/distribution-curve-on-chart/68338/1 "2023-01-06T22:54:09Z")

</div>

I am trying to create a chart to show a Normal Distribution of station cycle times.  
Using the tip from @JordanCClark in the below discussion I was able to produce this chart.  
My main issue here is the X - axis, my data is in seconds and it is giving this whole time stamp. How can I remove that?

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/6/86c3e61b990dd43523d387a3df6bc9f13fa904c8.png)

My query is:

```auto
SELECT Station, COUNT(Station) as CycleTime
FROM table
WHERE
Station > 15 AND Station < 106 AND
Date = CURDATE()

GROUP BY OP90
Order By OP90

```

> [@Normal Distribution Chart](https://forum.inductiveautomation.com/t/normal-distribution-chart/5179):
>
> If any new charting types will be added I would vote for a Normal Distribution or bell curve plotting chart. I do a lot of weight collection off of scales and stuff and that would be really handy. The box and whisker chart kind of does the same thing but people aren’t used to seeing that (at least where I work).

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [January 6, 2023, 11:06pm UTC](https://forum.inductiveautomation.com/t/distribution-curve-on-chart/68338/2 "2023-01-06T23:06:23Z")

</div>

Make a new X axis as a number type. The default is a Date type

---

<div class="post-metadata">

**Author:** ![Aaron\_Shivne](https://avatars.discourse-cdn.com/v4/letter/a/a8b319/32.png) [@Aaron\_Shivne](https://forum.inductiveautomation.com/u/Aaron_Shivne)\
**Post date:** [January 7, 2023, 1:13am UTC](https://forum.inductiveautomation.com/t/distribution-curve-on-chart/68338/3 "2023-01-07T01:13:57Z")

</div>

I had to change the data set properties for both the X and Y axis. Within the 'Chart Customizer'.