i need to generate a "distance" graph given x and y locations

[sneha]

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.....

 

[David Biddulph]

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?

 

[Bernard Liengme]

distance =SQRT((x2-x1)^2 + (y2-y1)^2)
best wishes

 

[sneha]

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....

 

[sneha]

something like this

x
i
i *(x,Y)
i
i *(x2,y2)
i
i *(x3,y3)
i
i---------- --------------y

 

[David Biddulph]

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..

 

[sneha]

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....

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

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]

If you are saying you want to change the distance between the axis scale
marks, then select an axis, right-click/ Format Axis/ Scale, adjust the
major unit to suit.
The same for the other axis if you want to change that too.
--
David Biddulph

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....

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

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....

:

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

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.....

 

[sneha]

Thank you David .....

If you are saying you want to change the distance between the axis scale
marks, then select an axis, right-click/ Format Axis/ Scale, adjust the
major unit to suit.
The same for the other axis if you want to change that too.
--
David Biddulph

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....

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

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....

:

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

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.....