# Perspective XY chart edit datasource/series

**URL:** <https://forum.inductiveautomation.com/t/perspective-xy-chart-edit-datasource-series/27899>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [August 30, 2019, 8:11am UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-edit-datasource-series/27899 "2019-08-30T08:11:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![gfx](https://avatars.discourse-cdn.com/v4/letter/g/96bed5/32.png) [@gfx](https://forum.inductiveautomation.com/u/gfx)\
**Post date:** [August 30, 2019, 8:11am UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-edit-datasource-series/27899/1 "2019-08-30T08:11:48Z")

</div>

Hi,

I tested new time series charts in 8.0.3, but right now I’m not going to use it.

Instead I have a series with values being timestamp and seconds since a machine is on, and would like to graph those seconds on the y axis and format them as HH:mm:ss . So on the yAxes object I set the render as date and the inputFormat as “M/d/yyyy HH:mm:ss”, but obviously being the data seconds and not milliseconds, I see very very small values on the Y axis.

So what I think I need is to multiply the column “seconds” of the dataset by 1000, then the graph should be populated correctly. I don’t want to edit the tag on change because I also need the real value of the seconds in other tabs of the project.

Any suggestions?

Thank you  
Giorgio

---

<div class="post-metadata">

**Author:** ![jlivingston](https://avatars.discourse-cdn.com/v4/letter/j/779978/32.png) [@jlivingston](https://forum.inductiveautomation.com/u/jlivingston)\
**Post date:** [August 30, 2019, 2:11pm UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-edit-datasource-series/27899/2 "2019-08-30T14:11:52Z")

</div>

`http://forum.inductiveautomation.com/t/print-perspective-xy-chart/26440` has some info that you may wish to consider before release. It seems that the folks at Inductive Automation / Ignition software have made a number of improvements in the Vision XY Chart, yet Perspective is another story when it comes to printing the result.  
Then there is ( drumroll )  
`https://support.inductiveautomation.com` Policies suggested then e-mail (priority possible) or call if policy and account status indicate.

---

<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:** [August 30, 2019, 3:47pm UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-edit-datasource-series/27899/3 "2019-08-30T15:47:31Z")

</div>

Hi Giorgio,

You could run your dataset through a transform script within the chart. Iterate through and multiply the ‘seconds’ by 1000. It would keep the original data intact for use elsewhere.

---

<div class="post-metadata">

**Author:** ![gfx](https://avatars.discourse-cdn.com/v4/letter/g/96bed5/32.png) [@gfx](https://forum.inductiveautomation.com/u/gfx)\
**Post date:** [August 30, 2019, 4:04pm UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-edit-datasource-series/27899/4 "2019-08-30T16:04:17Z")

</div>

Hi Jordan,

sincerely I don’t have any knowledge in python, if possible could you please make an example of the function/script you would use?

Really thank you  
Giorgio