A Chart that Updates Automatically as Data Size Changes?

  • Thread starter Thread starter Notclevr
  • Start date Start date
N

Notclevr

Hello again,

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

So it would be great if I could tell the chart to just use the value
that filled instead of a static number of cells. Of if I could tell i
to just use the values from (start date) to (end date). Becaus
sometimes the user will want a 1 year chart, and sometimes a 30 yea
chart. Any ideas?
 
Back
Top