software

Hello again,

I've written a spreadsheet that requests the user to enter the dates
and securities he or she wants to chart. It then creates a table with
that starting date and the values for those securities. I want to use
that table to create a chart, but my problem is that the data size is
variable.

So it would be great if I could tell the chart to just use the values
that filled instead of a static number of cells. Of if I could tell it
to just use the values from (start date) to (end date). Because
sometimes the user will want a 1 year chart, and sometimes a 30 year
chart. Any ideas??--
Notclevr
------------------------------------------------------------------------
Notclevr's Profile: www.excelforum.com/member.php...oamp;userid=30597
View this thread: www.excelforum.com/showthread...hreadid=502483See www.stfx.ca/people/bliengme/E...ps/Dynamic.htm
If you use Excel 2003, read Help about List - a chart made from a List
automatically updates
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Notclevrquot; gt; wrote in
message ...
gt;
gt; Hello again,
gt;
gt; I've written a spreadsheet that requests the user to enter the dates
gt; and securities he or she wants to chart. It then creates a table with
gt; that starting date and the values for those securities. I want to use
gt; that table to create a chart, but my problem is that the data size is
gt; variable.
gt;
gt; So it would be great if I could tell the chart to just use the values
gt; that filled instead of a static number of cells. Of if I could tell it
gt; to just use the values from (start date) to (end date). Because
gt; sometimes the user will want a 1 year chart, and sometimes a 30 year
gt; chart. Any ideas??
gt;
gt;
gt; --
gt; Notclevr
gt; ------------------------------------------------------------------------
gt; Notclevr's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30597
gt; View this thread: www.excelforum.com/showthread...hreadid=502483
gt;
Hi,

One way to do this would be to use dynamic named ranges for the data source.

You will find more information here,
peltiertech.com/Excel/Charts/Dynamics.html
www.tushar-mehta.com/excel/ne...rts/index.html

Cheers
Andy

Notclevr wrote:
gt; Hello again,
gt;
gt; I've written a spreadsheet that requests the user to enter the dates
gt; and securities he or she wants to chart. It then creates a table with
gt; that starting date and the values for those securities. I want to use
gt; that table to create a chart, but my problem is that the data size is
gt; variable.
gt;
gt; So it would be great if I could tell the chart to just use the values
gt; that filled instead of a static number of cells. Of if I could tell it
gt; to just use the values from (start date) to (end date). Because
gt; sometimes the user will want a 1 year chart, and sometimes a 30 year
gt; chart. Any ideas??
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info


Thank you both!--
Notclevr
------------------------------------------------------------------------
Notclevr's Profile: www.excelforum.com/member.php...oamp;userid=30597
View this thread: www.excelforum.com/showthread...hreadid=502483
Thank you both!--
Notclevr
------------------------------------------------------------------------
Notclevr's Profile: www.excelforum.com/member.php...oamp;userid=30597
View this thread: www.excelforum.com/showthread...hreadid=502483