Hello,
I am trying to make an XY scatter plot of a rather large non-contiguous data set. I am running into a problem in that the box to enter the X Values and Y Values is not large enough for the entire reference to the cells I want to chart.
They are all on the same sheet just typically (but not always) 7 cells apart.

For example the x values are on the Results sheet in cells B15, B18, B25....etc.
but to reference these I have to use:

=(Results!$B$15,Results!$B$18,Results!$B$25,Results!$B$31,Results!$B$37,Results!$B$44,Results!$B$50,Results!$B$56,Results!$B$63,Results!$B$69,Results!$B$75,Results!$B$82,Results!$B$88,Results!$B$94,Results!$B$101,Results!$B$107)

Is there a way to make this reference without having to repeat the " Results!$B " every time. All X data is on the same worksheet and in the same column and all Y data is on the same worksheet and in the same column.

Thanks for any suggestions.