Mar 20 2021 06:16 PM
Hi everyone, How do I plot several series of different sizes in the same graph?
Mar 21 2021 05:19 AM
SolutionNot 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
Result is
Mar 31 2021 10:16 AM
Thanks @Sergei Baklan, it is a very good solution, fantastic, this graph allows me to confirm the trend prior to opening a short trade.
Mar 21 2021 05:19 AM
SolutionNot 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
Result is