S
Shadow24
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!!
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!!