The project I'm currently working on turns out around 20 sets of results per day. Each set has 10 line graphs and 10 bar graphs associated with it. The number of points on the graph differs with every set of results and I have to re-set the graph's data range for every new set of results
I'm looking for a way to speed up this process as I typically have to access 400 or so graphs every day and manually change 800 or so entries. Each time I have a new set of results I go to each of the 20 graphs, click either on the line or the bar, and this brings up a formula that reads: =SERIES("'R' Value",'RT-Up'!$A$7:$A$25,'RT-Up'!$D$7:$D$25,1) which shows where the data is coming from. I'm hoping that I can use INDIRECT to replace the two instances of "25" in that formula ($A$25 & $D$25) and place the row number in an external reference cell.
I only discovered INDIRECT about half an hour ago (by courtesy of Carim in another thread) so I don't really know how to use it properly yet, but everything I've tried so far isn't working. Is this a situation where I can actually use INDIRECT and if so, how do I properly use it?