Code to plot a chart from a data set with a variable number of rows

Hi folks,

I'm sorry if this has been solved elsewhere, but every time I try to do a forum search I get an internal server error and it's driving me a little crazy.

My problem is this: I have a base spreadsheet which I'm dumping a whole lot of data into and I'm running a macro to do lots of data handling. Everything is working fine with that. What I want to add in is the capability to automatically plot some charts (XY scatter, no markers) using columns A,B,L,M,N where A is the X axis. I've no problem getting a code to plot a chart, my issue is defining the range for use in the chart. If it was always the same number of rows I'd be laughing but sometimes this data set will have 500 rows, other times it could have upwards of 5,000. Is there a snippet of code out there that would allow me to select a variable number of rows? I've tried selecting the entire column and that doesn't seem to work.

Thanks,
Michael