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