Can chart size be dynamically adjustable to fit data points?

  • Thread starter Thread starter Mitch
  • Start date Start date
M

Mitch

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.
 
Back
Top