Thread: Chart creation in VBA

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

Thanks Andy, I will check it out.