add a day to Source Data Value

  • Thread starter Thread starter sctroy
  • Start date Start date
S

sctroy

I am using this Source data in the Value in my chart. ='C:\Documents and
Settings\Randy\Desktop\[SCOTTRADE.xls]Symbols'!$F$4:$F$34 Is there a
way for it to change every time I update? I want it to get the
information form $F$4:$F$35 then the next day add $F$4:$F$36 and the
next day $F$4:$F$37..........
Can anyone help?
 
You could use a defined name something like
=offset($f$4,0,0,counta($F$F)-3,1)

insert>name>define
 
I am not real smart about this.
Where do I put your formula? =offset($f$4,0,0,counta($F$F)-3,1)


='C:\Documents and
Settings\Randy\Desktop\[SCOTTRADE.xls]Symbols'!$F$4:$F$34


='C:\Documents and
Settings\Randy\Desktop\[SCOTTRADE.xls]=offset($f$4,0,0,counta($F$F)-3,1)

If this is the corect place to put in your formula?
 
Back
Top