Hello,
I have a simple VBA script which updates the Source Data for a chart on a sheet. The correct Worksheet is selected, the chart gets activated, plot area gets activated.

Sub Macro1()

lr = 31

ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.PlotArea.Select
ActiveChart.SetSourceData Source:=Range("E24:H" & lr)

End Sub
It works fine on my PC, but when I send it to a colleague, it fails on this line with error 'Object doesn't support this action'

ActiveChart.SetSourceData Source:=Range("E24:H" & lr)
We both have Windows 10 with Excel 2016.

Any ideas?