# Need help in aligning data in XY chart/timeseries chart

**URL:** <https://forum.inductiveautomation.com/t/need-help-in-aligning-data-in-xy-chart-timeseries-chart/99359>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [December 3, 2024, 2:06pm UTC](https://forum.inductiveautomation.com/t/need-help-in-aligning-data-in-xy-chart-timeseries-chart/99359 "2024-12-03T14:06:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![srinivasan\_s](https://avatars.discourse-cdn.com/v4/letter/s/eb9ed0/32.png) [@srinivasan\_s](https://forum.inductiveautomation.com/u/srinivasan_s)\
**Post date:** [December 3, 2024, 2:06pm UTC](https://forum.inductiveautomation.com/t/need-help-in-aligning-data-in-xy-chart-timeseries-chart/99359/1 "2024-12-03T14:06:19Z")

</div>

I am working in charts. I need to recreate the data as below.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/e/feed31391ec27600ad7f4bac9d9cad66a3e85c89.png)  
My table schema looks like this,  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/8/687fe04a9d968c24fab8a9de191ad11553cfbafb.png)  
I tired to bind the data via named query to both charts but result is as below.  
For Timeseries Chart:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/5/2545d99cb97cc0e0107a78b63f804d344349912b.png)  
For XY xhart:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/9/192c46f948a741af1ef737ba9eeee2ab5246bac6.png)  
I tired series, axis not able to get this kind. Any one here kindly help on this.

---

<div class="post-metadata">

**Author:** ![Ujwal\_Wankhede](https://avatars.discourse-cdn.com/v4/letter/u/4af34b/32.png) [@Ujwal\_Wankhede](https://forum.inductiveautomation.com/u/Ujwal_Wankhede)\
**Post date:** [December 4, 2024, 1:46am UTC](https://forum.inductiveautomation.com/t/need-help-in-aligning-data-in-xy-chart-timeseries-chart/99359/2 "2024-12-04T01:46:17Z")

</div>

Hi  
The chart type you want to replicate is a **stacked and clustered column chart** , as demonstrated in the amCharts demo:Example [Stacked and Clustered Column Chart - amCharts](https://www.amcharts.com/demos-v4/stacked-clustered-column-chart-v4/)

 ![stacked-clustered-column-chart](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/a/aa61b29c9461f79c5c8d834f6911a2c7aec37e06.png)

To render this chart, use the following JSON configuration.  
The distance between two groups can be customized by modifying the `renderer` object properties. Note that these properties are not predefined, so you will need to add and configure them manually.  
[stackedxychart.json](https://forum.inductiveautomation.com/uploads/short-url/uifPhusDKlznnfOnjqB7iic1Owh.json) (52.9 KB)

---

<div class="post-metadata">

**Author:** ![srinivasan\_s](https://avatars.discourse-cdn.com/v4/letter/s/eb9ed0/32.png) [@srinivasan\_s](https://forum.inductiveautomation.com/u/srinivasan_s)\
**Post date:** [December 5, 2024, 5:00am UTC](https://forum.inductiveautomation.com/t/need-help-in-aligning-data-in-xy-chart-timeseries-chart/99359/3 "2024-12-05T05:00:53Z")

</div>

Thank you for your reply. Searching this solution for long, but you have helped me out!