Thread: Macro to automatically move chart data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
msdnquestion msdnquestion is offline
external usenet poster
  
Posts: 4
Default Macro to automatically move chart data
Some more info in this. In the macro here is one Line

ActiveChart.SeriesCollection(2).XValues = "=TTE'!R63C2:R76C2
ActiveChart.SeriesCollection(3).XValues = "=TTE'!R63C2:R76C2

I want the values R63C2:R76C2 to change to R64C2:R77C2 and so on for every
new week. Any help would be appreciated.

Reply With QuoteReply With Quote