# Two Separate Query Series into TimeSeriesChart formatting Challenge

**URL:** <https://forum.inductiveautomation.com/t/two-separate-query-series-into-timeserieschart-formatting-challenge/74773>\
**Category:** Ignition\
**Tags:** ignition81, perspective, namedqueries\
**Created:** [June 8, 2023, 3:58pm UTC](https://forum.inductiveautomation.com/t/two-separate-query-series-into-timeserieschart-formatting-challenge/74773 "2023-06-08T15:58:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![David\_Choi](https://avatars.discourse-cdn.com/v4/letter/d/34f0e0/32.png) [@David\_Choi](https://forum.inductiveautomation.com/u/David_Choi)\
**Post date:** [June 8, 2023, 3:58pm UTC](https://forum.inductiveautomation.com/t/two-separate-query-series-into-timeserieschart-formatting-challenge/74773/1 "2023-06-08T15:58:17Z")

</div>

Hello All,

Seems like I can't solve this, so I am throwing it out there to see if anyone knows better on using TimeSeriesChart formatting to achieve the following:

1. Change colors for each series dataset pulled by separate queries on the graph
2. Match y-axis formatting for each separate queries plotted on the same graph

Here's how it currently looks:

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

---

<div class="post-metadata">

**Author:** ![Jordan\_Archuleta](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordan_archuleta/32/49069_2.png) [@Jordan\_Archuleta](https://forum.inductiveautomation.com/u/Jordan_Archuleta)\
**Post date:** [June 26, 2023, 9:54pm UTC](https://forum.inductiveautomation.com/t/two-separate-query-series-into-timeserieschart-formatting-challenge/74773/2 "2023-06-26T21:54:28Z")

</div>

In regards to your first question, you can change the colors of each column by changing the style of the trends. Under the plots property, you will find the trends property where you will create a trend for each series. In the trend you create, you can specify the series to use and column for each pen/trend. You will then specify the key to the corresponding trend you want to control and change the color.  
In regards to your second question, you can add an axes under the plots property that all of your trends use. Here is a link to our user manual regarding the Time Series Chart and its properties for more information.  
[https://docs.inductiveautomation.com/display/DOC81/Perspective+-+Time+Series+Chart](https://docs.inductiveautomation.com/display/DOC81/Perspective+-+Time+Series+Chart)

Here is an example image from another forum post with the link to the post as well.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/b/bbae2262a0d9950627080e262776ac885903275b.png)

> [@Perspective - Time Series Chart , how to change color of line chart?](https://forum.inductiveautomation.com/t/perspective-time-series-chart-how-to-change-color-of-line-chart/39093/4):
>
> The simplest way is to set the colours in the props.defaultStyles.colors, e.g.: Alternatively, and more precisely, you can also set the colours, as I said in my previous post, in the this.props.plots[x].trends[y].columns[z] property. Using this method, you can specify what colour you want for each pen based on its pen name.