Changing of Chart's Column Data Series Conveniently

[mangocat123]

Hello Mr Excel Community!

I have multiple charts that I need to edit and I'm looking for a VBA solution to help me to do so.
How do I change the chart's column, without changing the rows (as the rows are fixed)?
For example, I would like to change the following series values

Chart 1:
$E22:$E30 ->$F22:$F30

Chart 2:
$E31:$E50 ->$F31:$F50

Chart 3:
$E55:$E60 ->$F55:$F60

Thanks for the help

 

[Asbestos_Jen]

Jon Peltier has an excellent article on different ways to use VBA to change the chart series here: Change Series Formula - Improved Routines - Peltier Tech

 

[mangocat123]

Jon Peltier has an excellent article on different ways to use VBA to change the chart series here: Change Series Formula - Improved Routines - Peltier Tech

Thank you so much for the help