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.
Bookmarks