SOLVED

Dynamic arrays in a same graph

Copper Contributor

Hi everyone, How do I plot several series of different sizes in the same graph?

3 Replies
best response confirmed by Maourice (Copper Contributor)
Solution

@Maourice 

Not sure what exactly you'd like to plot, but use TRANSPOSE() to show series

=TRANSPOSE(IFERROR(
  INDEX( $H$5:$H$504,  MATCH( L5,  $D$5:$D$504,  0 ) ):INDEX( $H$5:$H$504,  MATCH( M5,  $D$5:$D$504,  0 ) ),  "" ))

Expand data series as 

image.png

Result is

image.png

Thanks @Sergei Baklan, it is a very good solution, fantastic, this graph allows me to confirm the trend prior to opening a short trade. 

@Maourice , you are welcome

1 best response

Accepted Solutions
best response confirmed by Maourice (Copper Contributor)
Solution

@Maourice 

Not sure what exactly you'd like to plot, but use TRANSPOSE() to show series

=TRANSPOSE(IFERROR(
  INDEX( $H$5:$H$504,  MATCH( L5,  $D$5:$D$504,  0 ) ):INDEX( $H$5:$H$504,  MATCH( M5,  $D$5:$D$504,  0 ) ),  "" ))

Expand data series as 

image.png

Result is

image.png

View solution in original post