How do I set the source data to make this graph?

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!! :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top