Is it possible to assemble a series name in a cell and call it from chart data?

E.g. if the basic line from a chart looks like this:

=SERIES(Sheet2!$C$3;Sheet2!$B$4:$B$8;Sheet2!$C$4:$C$8;1)

and now I would like just to click on a specific cell where this exact command would be written, instead of marking the data seperately for each chart.

Overall I have around 100 rows with 100 columns. Each row is going to have around 10 charts. I have to find a solution that will help me to make charts quickly, without marking each set of numbers. I tried with dynamic name range, but it's not that less time consuming as i had hoped.