lovely ....Thank you David , its working.... but how to increase the bin
width ????

meaning

x
1000 |
500 |
0 |________________
0 100 500 1000 y

I want that it shud be 0, 10 ,20 , 30 so on....and not 0, 500,1000....






"David Biddulph" wrote:

If you've got your data in columns like this:
x y
3 4
1 6
4 7

Then delete the x from the top left hand corner cell and leave that empty
(as Excel gets confused otherwise).
Select your range including the x & y columns and including the header row
with the blank x header & the y header for the y column.
Insert/ Chart/ XY (& choose a sub-type to suit)/ choose other options to
suit as you go through.
[If you want to, you can put the x header back in after you've made your
chart.]
If you want to highlight a particular point, you can do that with Format
Data Point. If you click once on a series, then a second time to select a
point, then right-click will allow Format Data Point, and you can change its
colour or symbol or whatever..
--
David Biddulph

"sneha" wrote in message
...
Hi i want x-axis to be x-values i listed below and y-axis be y-values.....

when i say x,y = 3,4 , then i need a graph with x and y aixs ...with point
in the graph and the point is (3,4)...this point should be highlighted....

"David Biddulph" wrote:

Use the worksheet to calculate whatever parameters you want to put on
your
graph, then you can plot the graph. The formula you have can be used to
calculate your "distance" parameter between 1st & 2nd row points (though
of
course true distance would be the RSS of the Xdiff and Ydiff, not the
sum),
and similarly a "distance" between 2nd and 3rd row points. What do you
want
to plot against what in your chart?
--
David Biddulph

"sneha" wrote in message
...
Hi i am trying to create a graoh between x-axis and y-axis. basically
generating a simple distance formula graph :

x y
3 4
1 6
4 7
distance = (x2-x1) + (y2-y1)

can anyone help me generate this. All the charts in excel are not
giving
the
kind of graph i want.....