A Chart that Updates Automatically as Data Size Changes?
 

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

A Chart that Updates Automatically as Data Size Changes?
 

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

A Chart that Updates Automatically as Data Size Changes?
 

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

A Chart that Updates Automatically as Data Size Changes?
 

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

A Chart that Updates Automatically as Data Size Changes?
 

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