I'm trying to make an XYScatterPlot out of a single column of values:

XAxis = Cell
YAxis = Cell + 1

For example:

200
300
250
400

X1= 200 Y1 = 300
X2 = 300 Y2 = 250
X3 = 250 Y3 = 400

The way I have it set up now is by copying the values to a different column
and using the default graph setting when I set the Source range:

200 300
300 250
250 400

X1= 200 Y1 = 300
X2 = 300 Y2 = 250
X3 = 250 Y3 = 400 (Same)

In that case I need two columns which is redundant because the values are
the same...

I'm not sure if I set this using the ChartWizard method or what...

Thanks for any help!! :)