software

Hello,
I have a template spreadsheet, which includes data (several series of
variable length) and corresponding charts. Every time the data is imported
into this spreadsheet, the series' sizes are different. What I am trying to
do is having a designated cell one can use to manually specify the length of
currently imported data. But then the charts series references should be
adjusted accordingly. How can I specify those references in the chart setup
to allow them to change actual data series' boundaries according to the
value(s) stored somewhere?

Thank you in advance,

MikeMike

Sounds like you are in need of quot;dynamic rangesquot;

See Tushar Mehta's site for methods on creating dynamic range charts.

www.tushar-mehta.com/excel/ne...rts/index.htmlGord Dibben MS Excel MVP

On Fri, 20 Jan 2006 13:23:03 -0800, quot;Mike Faynbergquot; lt;Mike
gt; wrote:

gt;Hello,
gt;I have a template spreadsheet, which includes data (several series of
gt;variable length) and corresponding charts. Every time the data is imported
gt;into this spreadsheet, the series' sizes are different. What I am trying to
gt;do is having a designated cell one can use to manually specify the length of
gt;currently imported data. But then the charts series references should be
gt;adjusted accordingly. How can I specify those references in the chart setup
gt;to allow them to change actual data series' boundaries according to the
gt;value(s) stored somewhere?
gt;
gt;Thank you in advance,
gt;
gt;Mike