# Bar Chart

**URL:** <https://forum.inductiveautomation.com/t/bar-chart/4318>\
**Category:** Ignition\
**Created:** [April 19, 2012, 7:27am UTC](https://forum.inductiveautomation.com/t/bar-chart/4318 "2012-04-19T07:27:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![quper](https://avatars.discourse-cdn.com/v4/letter/q/aeb1de/32.png) [@quper](https://forum.inductiveautomation.com/u/quper)\
**Post date:** [April 19, 2012, 7:27am UTC](https://forum.inductiveautomation.com/t/bar-chart/4318/1 "2012-04-19T07:27:43Z")

</div>

Hello,  
How is it possible to change Bar Chart time axis format?  
I fill dataset with Postgres query. And I would like to change Bar Chart time axis format. For example if I view Day values, I would like time axis display hours only, not full timestamp. If I view Month values, I would like time axis to display days only and so on. On table i can format column Date Format for example as HH:mm:ss. Is it possible to do such in Bar Chart?  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/b5d72138ec3dc2d2f15f95844650a5ecd239a8e1.JPG)

---

<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:** [April 19, 2012, 9:36am UTC](https://forum.inductiveautomation.com/t/bar-chart/4318/2 "2012-04-19T09:36:24Z")

</div>

Are you pulling this from a query, then? If so, you can format the x-axis through the query. Here’s a MySQL example:

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/007191e224ed4c3e2b768accd0c39e085db60aa8.png)  
  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/5ad360a2e18b3896f66e74b056b63c167f4f35ec.png)

---

<div class="post-metadata">

**Author:** ![quper](https://avatars.discourse-cdn.com/v4/letter/q/aeb1de/32.png) [@quper](https://forum.inductiveautomation.com/u/quper)\
**Post date:** [April 24, 2012, 11:51am UTC](https://forum.inductiveautomation.com/t/bar-chart/4318/3 "2012-04-24T11:51:20Z")

</div>

Thank you!  
I made what I needed in query through substring by selecting timestamp as string.