Thread: add a day to Source Data Value

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

--
Don Guillett
SalesAid Software
donaldb@281.com
"sctroy" <sctroy.1yrfyy_1132431301.1833@excelforum-nospam.com> wrote in
message news:sctroy.1yrfyy_1132431301.1833@excelforum-nospam.com...
>
> 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?
>
>
> --
> sctroy
> ------------------------------------------------------------------------
> sctroy's Profile:
> http://www.excelforum.com/member.php...o&userid=25928
> View this thread: http://www.excelforum.com/showthread...hreadid=486565
>

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?

Here are examples and links to other examples:

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"sctroy" <sctroy.1yrndm_1132440902.1912@excelforum-nospam.com> wrote in
message news:sctroy.1yrndm_1132440902.1912@excelforum-nospam.com...
>
> 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?
>
>
> --
> sctroy
> ------------------------------------------------------------------------
> sctroy's Profile:
> http://www.excelforum.com/member.php...o&userid=25928
> View this thread: http://www.excelforum.com/showthread...hreadid=486565
>

another that describes completely
http://pubs.logicalexpressions.com/P...cle.asp?ID=518

--
Don Guillett
SalesAid Software
donaldb@281.com
"sctroy" <sctroy.1yrndm_1132440902.1912@excelforum-nospam.com> wrote in
message news:sctroy.1yrndm_1132440902.1912@excelforum-nospam.com...
>
> 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?
>
>
> --
> sctroy
> ------------------------------------------------------------------------
> sctroy's Profile:
> http://www.excelforum.com/member.php...o&userid=25928
> View this thread: http://www.excelforum.com/showthread...hreadid=486565
>