ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I set the source data to make this graph? (https://www.excelbanter.com/excel-programming/430856-how-do-i-set-source-data-make-graph.html)

Shadow24

How do I set the source data to make this graph?
 
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!! :)


All times are GMT +1. The time now is 11:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com