I have an excel spread sheet from which I must create graphs (XY scatter plots in this case)
I wish to create a macro to create the graphs as the data changes weekly and graphs of each set of data must be created.
Creating a macro to do this rather than having to manualy graph the data each week is not a problem.
My issue is that the amount of data in each column changes weekly, Column A is always the same parameter as is column B etc etc, however the length of the columns vary, this week all columns contain 22 entrys, this could be 50 or any other number next week.
Eg currently the macro will plot A1 to A22 against B1 to B22, if next weeks data sheet contains 50 values per column, the macro will plot A1 to A22 regardless and A23 to A50 will not appear on the graph.
Is there a method of making the macro continue to read the data from the column and plot it until an empty cell is reached?
Many thanks for any help on this matter.
Bookmarks