If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
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.
Linear Mode
