Thread: Macro to change chart references
View Single Post
  #5   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"

Is this what you meant?
Reply With QuoteReply With Quote