I am multiple series of data of varying lengths and would like to enter the
number of data points in a cell and have the corresponding chart be
dynamically adjusted to fit the current data sample. I tried specifying the
series values as follows:
=Sheet1!$B$6:INDIRECT(<cell holding the reference of the cell calculated to
hold the final data point,1).
It says there is an error in the formula but when I click OK it highlights
the exact range that I am trying to use.