Updating Line Chart with Named Range

Hi All,

I've been banging my head against the wall trying to finish off this small detail on part of a much larger macro. I have data on Sheet1 and a line chart ("Chart 1") on Sheet2. As the macro moves throughout the data on Sheet1 it updates a named range called "MyRange". The idea is to have the existing line chart on Sheet2 use use "MyRange" as it's data range (it contains both X and Y axis values). No matter what I've done I cannot get the chart to adopt this named range. When I tried recording excel does not capture that part of the process.

Can someone please help and advise on how I can get the line chart to use "MyRange" as its data range? I have left a code snippet below that is the jist of what I'm trying for.

Thank you in advance for any help you can provide

With Sheets("Sheet2")
 ActiveSheet.ChartObjects("Chart 1").Activate
    ActiveChart.SetSourceData Source:=MyRange
End With

Hi

does this work:

ActiveChart.SetSourceData Source:=range("MyRange")

I'm getting a 'method range of object global' failed on that line. Any suggestions on how I can amend this?

Thank you

Hi
does your workbook include a range named "MyRange"? if not, the macro will fail