Creating a Scatter Plot for any # of data

I need to write VBA code to create an XY scatter plot. The user needs to be able to enter their XY values, whether they have 2 XY values or 500 XY values, and then click a button and have it create their XY scatter plot.

The data will always begin in a certain cell, say, A1 (for X) and B1 (for Y), but the cell in which the data ends is dependent on how many data points the user enters.

I know I can use,

Please Login or Register  to view this content.

to select all the existing data in a column, however, I'm not sure if that will be useful here.

Thanks.