I have rows and columns with data. I then chart the data which links the
source data to the specific cells with absolute references.

If I try and copy the rows et al with data and the chart and paste another
group of the same below it, the rows et al of data change the cell reference
automatically to the corresponding rows where I paste them [relative
references] but the chart keeps the original source data cell references from
where it was before.

How can I make the source data update automatically to reference the
location I paste it to so I don't have to change the source data on every one?