Plot X and Y values

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
 
D

Debra Dalgleish

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
 
B

Bernard V Liengme

Hi Gary,
That trick works well for Line charts but an XY chart does not need a blank
cell - see Debra's answer.
Bernard
 
G

Gary Klass

J

Josh

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
 
J

J. Stacey

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)
 
Top