updating chart source after transposing rows
 

Hi all

I have a spreadsheet which has approx 30 different charts with it.

I have been asked to find out if there is any way in which after transposing
3 rows of data into columns that the charts can automatically update (which
would save me ages in resetting the source data locations) please?

Any help greatly appreciated.