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: http://www.excelforum.com/member.php...o&userid=30597
View this thread: http://www.excelforum.com/showthread...hreadid=502483

See http://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

"Notclevr" wrote in
message ...

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:
http://www.excelforum.com/member.php...o&userid=30597
View this thread: http://www.excelforum.com/showthread...hreadid=502483

Hi,

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

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

Cheers
Andy

Notclevr wrote:
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??



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thank you both!


--
Notclevr
------------------------------------------------------------------------
Notclevr's Profile: http://www.excelforum.com/member.php...o&userid=30597
View this thread: http://www.excelforum.com/showthread...hreadid=502483

Thank you both!


--
Notclevr
------------------------------------------------------------------------
Notclevr's Profile: http://www.excelforum.com/member.php...o&userid=30597
View this thread: http://www.excelforum.com/showthread...hreadid=502483