Dear Excel users,
I've recently learnt how to create charts that dynamically update to new sets of updated data, and I've found it pretty amazing.
The method I have used is through giving specific names to ranges and then using the OFFSET and COUNTA functions to make them match...however there is a problem with this method.
I am making graphs for a wide range of time series data and while the values on the X axis are the same for all the charts, of course the Y values vary for each chart and that means that I have to manually name all these ranges with different names and that takes a lot of time.

My Question is is there a way to do all this process of naming all the different ranges through a VBA code?
I am really new at VBA coding so please excuse me if this is a really stupid question :D Looking forward to your reply, thanks!