If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Plot X and Y values
I need to create a chart in Excel in which each point has
an X and Y value, reading the info from a table of data. When using the "scatter" chart type, it doesn't do that, instead it draws two series' of points, one series for the X values and one for the Y. Thanks, Josh |
#2
|
|||
|
|||
Plot X and Y values
Josh
You can enter the x values on the source data step of the chart wizard, but if you want to do it automatically, set up your data like this (blank cell) Yvarlabel 1 10 2 15 3 17 i.e., with a label fo the y-value column and none for the x-values. Josh wrote: I need to create a chart in Excel in which each point has an X and Y value, reading the info from a table of data. When using the "scatter" chart type, it doesn't do that, instead it draws two series' of points, one series for the X values and one for the Y. Thanks, Josh -- Gary Klass Editor, PSRT-L 4600 Politics and Government Illinois State University Normal, Illinois 61790 http://LILT.ILSTU.EDU/gmklass (309) 438-7852 (fax) 438-7638 The Chart of the Week: http://LILT.ILSTU.EDU/gmklass/cow |
#3
|
|||
|
|||
Plot X and Y values
There may be some data in adjacent columns that is confusing the Chart
Wizard. Select only the series data and labels, and run the chart wizard, and it should set up the chart correctly. X Y 1 10 2 12 3 15 4 17 Josh wrote: I need to create a chart in Excel in which each point has an X and Y value, reading the info from a table of data. When using the "scatter" chart type, it doesn't do that, instead it draws two series' of points, one series for the X values and one for the Y. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
Plot X and Y values
Hi Gary,
That trick works well for Line charts but an XY chart does not need a blank cell - see Debra's answer. Bernard "Gary Klass" wrote in message ... Josh You can enter the x values on the source data step of the chart wizard, but if you want to do it automatically, set up your data like this (blank cell) Yvarlabel 1 10 2 15 3 17 i.e., with a label fo the y-value column and none for the x-values. Josh wrote: I need to create a chart in Excel in which each point has an X and Y value, reading the info from a table of data. When using the "scatter" chart type, it doesn't do that, instead it draws two series' of points, one series for the X values and one for the Y. Thanks, Josh -- Gary Klass Editor, PSRT-L 4600 Politics and Government Illinois State University Normal, Illinois 61790 http://LILT.ILSTU.EDU/gmklass (309) 438-7852 (fax) 438-7638 The Chart of the Week: http://LILT.ILSTU.EDU/gmklass/cow |
#5
|
|||
|
|||
Plot X and Y values
Debra's right.
(but once before it didn't work for me, so I started doing it my way) Bernard V Liengme wrote: Hi Gary, That trick works well for Line charts but an XY chart does not need a blank cell - see Debra's answer. Bernard "Gary Klass" wrote in message ... Josh You can enter the x values on the source data step of the chart wizard, but if you want to do it automatically, set up your data like this (blank cell) Yvarlabel 1 10 2 15 3 17 i.e., with a label fo the y-value column and none for the x-values. Josh wrote: I need to create a chart in Excel in which each point has an X and Y value, reading the info from a table of data. When using the "scatter" chart type, it doesn't do that, instead it draws two series' of points, one series for the X values and one for the Y. Thanks, Josh -- Gary Klass Editor, PSRT-L 4600 Politics and Government Illinois State University Normal, Illinois 61790 http://LILT.ILSTU.EDU/gmklass (309) 438-7852 (fax) 438-7638 The Chart of the Week: http://LILT.ILSTU.EDU/gmklass/cow -- Gary Klass Editor, PSRT-L 4600 Politics and Government Illinois State University Normal, Illinois 61790 http://LILT.ILSTU.EDU/gmklass (309) 438-7852 (fax) 438-7638 The Chart of the Week: http://LILT.ILSTU.EDU/gmklass/cow |
#6
|
|||
|
|||
Plot X and Y values
Thanks, both of those suggestions worked in that they
resulted in properly plotting the X and Y value of each point. However I can't see how to identify the data points with their proper labels, which come from the column to the left of the X values. If I choose data label it just inserts the X value next to the point on the chart. Any further ideas on this? thanks again, Josh -----Original Message----- Josh You can enter the x values on the source data step of the chart wizard, but if you want to do it automatically, set up your data like this (blank cell) Yvarlabel 1 10 2 15 3 17 i.e., with a label fo the y-value column and none for the x-values. Josh wrote: I need to create a chart in Excel in which each point has an X and Y value, reading the info from a table of data. When using the "scatter" chart type, it doesn't do that, instead it draws two series' of points, one series for the X values and one for the Y. Thanks, Josh -- Gary Klass Editor, PSRT-L 4600 Politics and Government Illinois State University Normal, Illinois 61790 http://LILT.ILSTU.EDU/gmklass (309) 438-7852 (fax) 438-7638 The Chart of the Week: http://LILT.ILSTU.EDU/gmklass/cow . |
#7
|
|||
|
|||
Plot X and Y values
Josh -
There are a couple free utilities you can install to do this easily: Rob Bovey's Chart Labeler (http://appspro.com) John Walkenbach's Chart Tools (http://j-walk.com) - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Josh wrote: Thanks, both of those suggestions worked in that they resulted in properly plotting the X and Y value of each point. However I can't see how to identify the data points with their proper labels, which come from the column to the left of the X values. If I choose data label it just inserts the X value next to the point on the chart. Any further ideas on this? thanks again, Josh -----Original Message----- Josh You can enter the x values on the source data step of the chart wizard, but if you want to do it automatically, set up your data like this (blank cell) Yvarlabel 1 10 2 15 3 17 i.e., with a label fo the y-value column and none for the x-values. Josh wrote: I need to create a chart in Excel in which each point has an X and Y value, reading the info from a table of data. When using the "scatter" chart type, it doesn't do that, instead it draws two series' of points, one series for the X values and one for the Y. Thanks, Josh -- Gary Klass Editor, PSRT-L 4600 Politics and Government Illinois State University Normal, Illinois 61790 http://LILT.ILSTU.EDU/gmklass (309) 438-7852 (fax) 438-7638 The Chart of the Week: http://LILT.ILSTU.EDU/gmklass/cow . |
#8
|
|||
|
|||
Plot X and Y values
is it possible to include a 3rd column? for example, each of these (x,y) coordinates corresponds to an item listed in a 3rd column. can i set the 3rd column to appear as a label/value, etc. for each point? thanks for any help. js -----Original Message----- There may be some data in adjacent columns that is confusing the Chart Wizard. Select only the series data and labels, and run the chart wizard, and it should set up the chart correctly. X Y 1 10 2 12 3 15 4 17 Josh wrote: I need to create a chart in Excel in which each point has an X and Y value, reading the info from a table of data. When using the "scatter" chart type, it doesn't do that, instead it draws two series' of points, one series for the X values and one for the Y. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html . |
#9
|
|||
|
|||
Plot X and Y values
josh, i just posted above with the same question. i need
to incorporate a 3rd set of values in the chart. does anybody know how to do it? thanks. js -----Original Message----- Thanks, both of those suggestions worked in that they resulted in properly plotting the X and Y value of each point. However I can't see how to identify the data points with their proper labels, which come from the column to the left of the X values. If I choose data label it just inserts the X value next to the point on the chart. Any further ideas on this? thanks again, Josh -----Original Message----- Josh You can enter the x values on the source data step of the chart wizard, but if you want to do it automatically, set up your data like this (blank cell) Yvarlabel 1 10 2 15 3 17 i.e., with a label fo the y-value column and none for the x-values. Josh wrote: I need to create a chart in Excel in which each point has an X and Y value, reading the info from a table of data. When using the "scatter" chart type, it doesn't do that, instead it draws two series' of points, one series for the X values and one for the Y. Thanks, Josh -- Gary Klass Editor, PSRT-L 4600 Politics and Government Illinois State University Normal, Illinois 61790 http://LILT.ILSTU.EDU/gmklass (309) 438-7852 (fax) 438-7638 The Chart of the Week: http://LILT.ILSTU.EDU/gmklass/cow . . |
#10
|
|||
|
|||
Plot X and Y values
j. stacey wrote:
is it possible to include a 3rd column? for example, each of these (x,y) coordinates corresponds to an item listed in a 3rd column. can i set the 3rd column to appear as a label/value, etc. for each point? I think Jon already pointed you in the direction of the XY chart labeler from www.appspro.com. The feature you desire is not built in to excel, but that little add-in makes it a snap to do exactly what you describe. Dave dvt at psu dot edu |
|
Thread Tools | |
Display Modes | |
|
|