Graph data source spilt by column insert

I have several graphs that refer to individual worksheets that only look at a data source of 1A to 13B.

I have VBA'd a type of automatic updating, by sorting all the data in a worksheet and then "Cut & Paste" the required column to column "B".

However, the data source for the graph then get's chopped in half and keeps referencing the previous "B" column (which is now "C")
So the new "B" column is not included. I have tried to reset the datasource for the Charts but because of the way excel hides things I've been unable to..

Q): Is there a way to stop the splitting of the datasource when a cut column/row is inserted?

Thank you