Can chart size be dynamically adjustable to fit data points?
 

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.

Can chart size be dynamically adjustable to fit data points?
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Mitch" wrote in message
...
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.

Can chart size be dynamically adjustable to fit data points?
 

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

"Andy Pope" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Mitch" wrote in message
...
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.