Thread: Macro to change chart references
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jobe Jobe is offline
external usenet poster
  
Posts: 10
Default Macro to change chart references
Thanks Tom,

But it did not work. This is what I tried,

ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ChartArea.Select
ActiveChart.SeriesCollection(1).XValues = "=" & s & "'!R20C1:R54C1"
Reply With QuoteReply With Quote