Sorry i am new to this forum and as when i signed up it asked what
versions i was using i thought the information was public knowledge , I
am in fact using excel 2002



:nw)

Climbatized;364313 Wrote:
It would be helpful to know what version of Excel you are using. If
it's
excel 2007...

(1) Click the "insert" tab

(2) Click on the "scatter" button in the "Charts" group.

(3) Click a chart type from the drop down menu ie. with/without lines
etc.
This will insert an empty chart box onto your sheet.

(4) Right click on the empty chart and click "select data" - this will
bring
up the "select data source" window.

(5) In this new window, click the "add" button. This will bring up the
"Edit
Series" window with three text boxes.

(6) in the "series name" box, give your data a name - this can be
anything,
ie.. fred/data1/mydata etc.

(7) Click on the little "select range" button to the right of the
"series x
values" textbox - once the next "edit series" window appears, just
highlight
the appropriate x-coordinates from your spreadsheet with the cursor.
Excel
will then write the appropriate formula into the textbox. Click the
button
with the little red arrow in the "edit series" window to return.

(8) Repeat step 7 for the "series y values" box

(9) Click OK on the "edit series" window

(10) Click OK on the "Select data source" window.

That should be it, you should have a nice x-y plot of your data. Hope
this
helps, if it's an earlier version of excel, things look slightly
different
but the method is very similar.

"Wobbles" wrote:


Help . I have been trying and failing to sucessfully plot x , y co
ordinates from worksheet data containing 3 columns One being the name
of
the location the next being the x co ords and the final one bieng the
y
co ord.
I can not get these simple points to be plotted. I am using x,y
scatter but tried bubble too
Why is this apparently simple task getting the better of me.

Ps the number of records may eventualy exceed 255 points and that
seems
to pop up as an issue too


--
Wobbles

------------------------------------------------------------------------
Wobbles's Profile: 'The Code Cage Forums - View Profile: Wobbles'
(http://www.thecodecage.com/forumz/member.php?userid=365)
View this thread: 'Simple ( I thought) X Y Axis point plotting - The
Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=102087)




--
Wobbles
------------------------------------------------------------------------
Wobbles's Profile: http://www.thecodecage.com/forumz/member.php?userid=365
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=102087