Combine & Shorten Code

Try this

Please Login or Register  to view this content.

This assumes that you have a dynamic Data Source Table that you want to copy to a Chart Data Table, in reverse order.

You can run this code with all the chart sheets hidden.

Try the demo book.

Hide sheet "2.4.1 T1-Chart" where I have put some dummy data

Run either macro "Test" or "Update_AllCharts"

Unhide sheet "2.4.1 T1-Chart and check the result

I have set the Option General to R1C1 reference for easier reading of the code.

Hope this helps

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

Hi Marc,

Thanks a lot for your reply. It works perfectly. I really appreciate it.

Thanks again man!

Regards.