Spreadsheet: 842492d1694558614-line-chart-for-selective-period-offset-last-n-days-analystbank-
Sheet: Sheet1

 |  | Last Days | From | To
 |  | 30
Date | Column1 | Column2 | Series1 | Series2
2023-04-25 00:00:00 |  |  | 31 | 31
2023-04-26 00:00:00 |  |  | 36 | 36
2023-04-27 00:00:00 |  |  | 46 | 46
2023-04-28 00:00:00 |  |  | 57 | 57
2023-05-02 00:00:00 |  |  | 61 | 46.2
2023-05-03 00:00:00 |  |  | 66 | 53.2
2023-05-04 00:00:00 |  |  | 74 | 60.8
2023-05-05 00:00:00 |  |  | 74 | 66.4
2023-05-08 00:00:00 |  |  | 80 | 71
2023-05-09 00:00:00 |  |  | 69 | 72.6
2023-05-10 00:00:00 |  |  | 34 | 66.2
2023-05-11 00:00:00 |  |  | 55 | 62.4
2023-05-12 00:00:00 |  |  | 76 | 62.8
2023-05-15 00:00:00 |  |  | 75 | 61.8
2023-05-16 00:00:00 |  |  | 78 | 63.6 |  |  | Column Reference |  | Named Range |  | [NAME]
2023-05-17 00:00:00 |  |  | 59 | 68.6 |  |  | A |  | Date |  | =OFFSET(Sheet1!$A$12,0,0,COUNTA(Sheet1!$A:$A)-1)
2023-05-18 00:00:00 |  |  | 71 | 71.8 |  |  | D |  | ColD |  | =OFFSET(Sheet1!$D$12,0,0,COUNTA(Sheet1!$D:$D)-1)
2023-05-19 00:00:00 |  |  | 43 | 65.2 |  |  | E |  | D5AVG |  | =OFFSET(Sheet1!$E$12,0,0,COUNTA(Sheet1!$E:$E)-1)
2023-05-22 00:00:00 |  |  | 40 | 58.2
2023-05-23 00:00:00 |  |  | 55 | 53.6
2023-05-24 00:00:00 |  |  | 56 | 53
2023-05-25 00:00:00 |  |  | 75 | 53.8
2023-05-26 00:00:00 |  |  | 90 | 63.2
2023-05-29 00:00:00 |  |  | 75 | 70.2
2023-05-30 00:00:00 |  |  | 77 | 74.6
2023-05-31 00:00:00 |  |  | 98 | 83
2023-06-01 00:00:00 |  |  | 97 | 87.4
2023-06-02 00:00:00 |  |  | 114 | 92.2
2023-06-05 00:00:00 |  |  | 136 | 104.4
2023-06-06 00:00:00 |  |  | 124 | 113.8
2023-06-07 00:00:00 |  |  | 154 | 125
2023-06-08 00:00:00 |  |  | 96 | 124.8
2023-06-09 00:00:00 |  |  | 69 | 115.8
2023-06-12 00:00:00 |  |  | 30 | 94.6
 |  |  | 30 | 75.8
 |  |  | 30 | 51
 |  |  | 30 | 37.8
 |  |  | 30 | 30
 |  |  | 30 | 30
 |  |  | 30 | 30
2023-06-23 00:00:00 |  |  | 35 | 31
2023-06-26 00:00:00 |  |  | 47 | 34.4
2023-06-27 00:00:00 |  |  | 65 | 41.4
2023-06-28 00:00:00 |  |  | 103 | 56
2023-06-30 00:00:00 |  |  | 112 | 72.4
2023-07-03 00:00:00 |  |  | 148 | 95
2023-07-04 00:00:00 |  |  | 110 | 107.6
2023-07-05 00:00:00 |  |  | 110 | 116.6
2023-07-06 00:00:00 |  |  | 155 | 127
2023-07-07 00:00:00 |  |  | 113 | 127.2
2023-07-10 00:00:00 |  |  | 102 | 118
2023-07-11 00:00:00 |  |  | 108 | 117.6
2023-07-12 00:00:00 |  |  | 135 | 122.6
2023-07-13 00:00:00 |  |  | 145 | 120.6
2023-07-14 00:00:00 |  |  | 112 | 120.4
2023-07-17 00:00:00 |  |  | 180 | 136
2023-07-18 00:00:00 |  |  | 121 | 138.6
2023-07-19 00:00:00 |  |  | 124 | 136.4
2023-07-20 00:00:00 |  |  | 133 | 134
2023-07-20 00:00:00 |  |  | 113 | 134.2
2023-07-24 00:00:00 |  |  | 152 | 128.6
2023-07-24 00:00:00 |  |  | 166 | 137.6
2023-07-26 00:00:00 |  |  | 132 | 139.2
2023-07-27 00:00:00 |  |  | 132 | 139
2023-07-28 00:00:00 |  |  | 147 | 145.8
2023-07-31 00:00:00 |  |  | 147 | 144.8
2023-08-01 00:00:00 |  |  | 217 | 155
2023-08-02 00:00:00 |  |  | 100 | 148.6
2023-08-03 00:00:00 |  |  | 80 | 138.2
2023-08-03 00:00:00 |  |  | 128 | 134.4
2023-08-07 00:00:00 |  |  | 149 | 134.8
2023-08-08 00:00:00 |  |  | 149 | 121.2
2023-08-09 00:00:00 |  |  | 121 | 125.4
2023-08-10 00:00:00 |  |  | 121 | 133.6
2023-08-10 00:00:00 |  |  | 98 | 127.6