# Making bar chart with named query

**URL:** <https://forum.inductiveautomation.com/t/making-bar-chart-with-named-query/109239>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [August 1, 2025, 6:54am UTC](https://forum.inductiveautomation.com/t/making-bar-chart-with-named-query/109239 "2025-08-01T06:54:29Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![uy\_huynh](https://avatars.discourse-cdn.com/v4/letter/u/54ee81/32.png) [@uy\_huynh](https://forum.inductiveautomation.com/u/uy_huynh)\
**Post date:** [August 1, 2025, 6:54am UTC](https://forum.inductiveautomation.com/t/making-bar-chart-with-named-query/109239/1 "2025-08-01T06:54:29Z")

</div>

Hi all,  
If I have a named query that query a daily total data for each location, how can I implement it into a bar chart?  
Only worked if I have one row of data. If my set of data has more than 1 row data, it doesn't display the data.  
Any suggestions? I have tried to transfer my date into millis but it still doesn't want to display the 2nd row data.  
Thanks

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

---

<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:** [August 1, 2025, 8:08am UTC](https://forum.inductiveautomation.com/t/making-bar-chart-with-named-query/109239/2 "2025-08-01T08:08:17Z")

</div>

You are trying to do this with the Time Series Chart component.

Try the XY Chart instead.  
I would set the `xAxes.0.render : category` to get evenly spaced bars.

---

<div class="post-metadata">

**Author:** ![uy\_huynh](https://avatars.discourse-cdn.com/v4/letter/u/54ee81/32.png) [@uy\_huynh](https://forum.inductiveautomation.com/u/uy_huynh)\
**Post date:** [August 3, 2025, 11:04pm UTC](https://forum.inductiveautomation.com/t/making-bar-chart-with-named-query/109239/3 "2025-08-03T23:04:55Z")

</div>

Thanks for the reply Transistor.  
Is there anyway I can stack 3 of them into 1 bar? I tried the xy chart but seems like separting into 3 bars is the only option

---

<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:** [August 3, 2025, 11:14pm UTC](https://forum.inductiveautomation.com/t/making-bar-chart-with-named-query/109239/4 "2025-08-03T23:14:10Z")

</div>

Use the XY Chart.  
`series.0.render : column`  
`series.1.render : column`  
`series.2.render : column`  
`series.0.column.appearance.stacked : true`  
`series.1.column.appearance.stacked : true`  
`series.2.column.appearance.stacked : true`

Make sure that  
`series.0.yAxis`  
`series.1.yAxis`  
`series.2.yAxis`  
all point to the same y-axis, otherwise they won't stack.

---

<div class="post-metadata">

**Author:** ![uy\_huynh](https://avatars.discourse-cdn.com/v4/letter/u/54ee81/32.png) [@uy\_huynh](https://forum.inductiveautomation.com/u/uy_huynh)\
**Post date:** [August 3, 2025, 11:27pm UTC](https://forum.inductiveautomation.com/t/making-bar-chart-with-named-query/109239/5 "2025-08-03T23:27:00Z")

</div>

Oh man you saved me a lot of time.

Going to try this: [Stacked Bar Chart in Perspective - Detailed Steps - Ignition - Inductive Automation Forum](https://forum.inductiveautomation.com/t/stacked-bar-chart-in-perspective-detailed-steps/47107)

But I guess no need anymore 😃

---

<div class="post-metadata">

**Author:** ![uy\_huynh](https://avatars.discourse-cdn.com/v4/letter/u/54ee81/32.png) [@uy\_huynh](https://forum.inductiveautomation.com/u/uy_huynh)\
**Post date:** [August 3, 2025, 11:27pm UTC](https://forum.inductiveautomation.com/t/making-bar-chart-with-named-query/109239/6 "2025-08-03T23:27:29Z")

</div>

Wait. It has same approach.