Changing source data in graph

[RichardMGreen]

Hi all

Is it possible to use a macro to change the source data references of a chart?
I only want to change the sheet name as the cell references themselves will be identical.

Any help with coding would be greatly appreciated.

 

[Trevor G]

Richard,

Have a look here to see if it helps.

Sub Macro2()
'
' Macro2 Macro
'

'
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlColumnClustered
ActiveChart.SetSourceData Source:=Sheets("Sheet4").Range("A1:F9")
Range("L5").Select
End Sub

 

[RichardMGreen]

Thanks Trevor.

I'm looking to do more of a replacement of sheet names if at all possible.
I can supply the original sheet name and the sheet name it will become, I'm just struggling with the replacement bit.

 

[RichardMGreen]

Hi Trevor, thanks for that.
I'm looking to do more of a find/replace type thing on the sheet names if possible?

 

[Jon Peltier]

This article may be helpful: Change Series Formula – Improved Routines.

 

[RichardMGreen]

Thanks for that, I'll have a look.