Hi,
I would like to create a chart using VBA. However, my x and y axis data can change (ie. it may be 30 rows long one time and then next time only be 20 rows long)
Is there a way that the code can adjust for this and look for all the relevant data in the Column?
Please note - I wish to create the chart on Sheet 2 and the Data is on Sheet 1.
THANKS!
Kind regards,
Lewis
Bookmarks