Plot X and Y values

  • Thread starter Thread starter Josh
  • Start date Start date
J

Josh

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
 
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
 
Hi Gary,
That trick works well for Line charts but an XY chart does not need a blank
cell - see Debra's answer.
Bernard
 
Debra's right.

(but once before it didn't work for me, so I started doing it my way)
Hi Gary,
That trick works well for Line charts but an XY chart does not need a blank
cell - see Debra's answer.
Bernard
Click to expand...

--
Gary Klass
(e-mail address removed)
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
 
Josh, check out Jon Peltier's response to me in a thread
above. I downloaded the appspro add-in and it worked!

Hi Jo -

There are a couple of free add-ins that can handle
labeling of data points:

Rob Bovey's Chart Labeler (http://appspro.com)
John Walkenbach's Chart Tools (http://j-walk.com)
 
Back
Top