Excel graph drawn by macro doesn't highlight data in the sheet when clicked

[Ed Harris]

Hi, I am making lots of small graphs to help characterise some data so used the Record Macro Function, which works fine, but if I click on the chart line the data is not highlighted in the sheet as it would normally. Any Ideas why not? Here is the macro.

Sub ABC()
'
' ABC Macro
'

'
ActiveCell.Offset(-4, 0).Range("A1:C9").Select
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlLineMarkers
ActiveChart.SetSourceData Source:=Range("'July to Sept'!$C$11824:$E$11832")
End Sub

 

[Ed Harris]

I have found the solution. In case anyone else has the same problem, the macro was not recording in "use relative reference mode", despite being set in that mode, so when I click the plot it highlighted a location off screen.