Hello,

I'm working on creating a spreadsheet that needs to create a smooth scatter plot based on data from a range of cells.

There are two sets of data that I would like to plot, with a start of "A15", "B15" and "E15" with the last cell in each column is the same for each file, however different files might have different amounts of data.

I created a variable for the x range and the two y ranges, since the number of entries will change (that code is fine).

How am I able to plot these two sets of data onto one scatter plot, on the sheet where the data is?


Thank you,

John