Change reference columns of a chart

[bruty]

Hi all.

I have a spreadsheet with 90+ charts on, and need to change the cell references by 2 columns (i.e. from column G to column E). Is there a quick way to do this without having to go in to each chart manually?

I tried recording a macro, but instead of just replacing the G for E it types in the who range it is looking for, so this wouldn't really work as as each chart has a different row reference so the same code wouldn't work (unless there's a way to set the row the same as it was?)

Thanks in advance.

 

[njimack]

Take a look at https://peltiertech.com/change-series-formula-improved-routines/

 

[bruty]

Take a look at https://peltiertech.com/change-series-formula-improved-routines/

Thanks. Looks like it will do the trick.