XY Scatter Plot Data Series Additions within a loop

Hi,

I am trying to create an XY Scatter Plot within Excel 2003 that has 5 series of data on it. My data exists in two columns (A and B) on the spreadsheet. There is an unspecified number of rows of data within each data set, and each set of data is located 8 rows down from the end of the previous data set (all within columns A and B). Because the number of rows in each data set is variable, I can't simply create a loop that selects a pre-determined number of rows.

To solve this issue, I created a Do While loop that uses the End(xlDown) function. The code I wrote to graph the data can properly plot one range when the code is located outside of the loop, but once placed inside the loop, running the maco simply creates a spreadsheet with no data plotted.

My issue is with the data series creation - the data is not being properly placed on the chart created within the workbook. Does anyone see an error/mistake in this code?

I am new to writing Excel Macros, so please forgive any seemingly simple errors I have made.

Thank you for the help.

My code is below, and I have attached the spreadsheet.

Please Login or Register  to view this content.

Hi Andy,

This worked perfectly - thank you for the help! This was exactly what I was looking for.

Thank you,

Justin