CHART Formula Change VBA

[xluser2007]

Hi md,

I think my previous post was too large and got cut.

Basically, the code in my original post worked, just rebooted Excel and re-ran and it worked fine.

I have written code to do my required task, but it is far too large and could be made more maintable and elegant (as it repeats itself with different parameters).

I've attached my code in a TXT file for reference.

Any help to make this more elegant and maintanble is appreciated.