Hallo VBA Experts !


I have made a dynamical array (all by myself :D), that will consist of an unknown number of columns (years) and an unknown number of rows. Please see attachment and code.

need help garphs 25:6.xlsm

By using my produced array “MyArray" I want to produce a graph for each row (minus the header row) with the Chart name from column one in the array. The graph will have y values from the current row and Category(X) axis label values must be from row one for ALL graphs. Hope you understand ? I want these graphs to be put on new sheet with the name DD-MM-YYYY HHMM.

I have tried to illustrate this on the attached file.


Can anybody help me with producing these unknown number of graphs with the unknown number of data point (years)?? It would be great to have your help!!


Thank you very much in advance!!! Please write if you have any questions!


Regards
damp