Can anyone tell me how to use VBA code for the dynamic chart? I have 30 charts need to be plotted as dynamic chart. I know how to do it manually but it is very time consuming. However, there is always an error message for defining the name range in VBA.
Thanks!
Wei