Can chart size be dynamically adjustable to fit data points?

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

 

[Andy Pope]

Hi,

You need to create a named range rather than trying to use formula in the
series reference box.
See here for more detail
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

 

[Mitch]

Thanks Andy. What I have reviewed so far comes close to what I need.
Mitch