How to build a graph from an array?

Question

Google Sheets

https://docs.google.com/spreadsheets/d/1GP-U3daCDn...

There is a range with years and you need to make a graph:
1. search in the array for the beginning of the given year, in my example it is 2020
2. look from the array on the left ( red) which figure refers to the year and based on this the graph is built.

How can this be done?

Answer 1

1) Regroup the data into a flat table

=SEQUENCE(48;1;1987;1)
=ArrayFormula('расчеты'!$B$8:$B$13)

2) Make a choice of the year in a separate cell
3) Filter the source data with the FILTER() function
=ArrayFormula(filter(0+A:B;+A:A>=$D$1))
4) Use this data and build a graph

Answer 2

and how to make a universal formula, regardless of how many digits there are in cell B8, so that it distributes into a column with repetition
=TRANSP(REGEXEXTRACT(""&B6;"(\d)(\d)(\d)(\d)(\ d)(\d)"))