Does anyone know how to write a macro in order to select the data range of a
chart?

The reason is that I have a macro which inserts a line and then copies data
into that new line from another worksheet. Doing this adjusts the data range
of the chart which already exists in the worksheet and means that the new
line is ignored....

I tried to record a macro to do this but it falls over after clicking select
data.