Thread: 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??

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" <Notclevr.21u78o_1137598802.4146@excelforum-nospam.com> wrote in
message news:Notclevr.21u78o_1137598802.4146@excelforum-nospam.com...
>
> 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!