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

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

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

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

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

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

.

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

.

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

.

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

.

.

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