Thread: add a day to Source Data Value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
sctroy
 
Posts: n/a
Default 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?


--
sctroy
------------------------------------------------------------------------
sctroy's Profile: http://www.excelforum.com/member.php...o&userid=25928
View this thread: http://www.excelforum.com/showthread...hreadid=486565

Reply With QuoteReply With Quote