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

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

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

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

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

distance =SQRT((x2-x1)^2 + (y2-y1)^2)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

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

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

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

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

something like this

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



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

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

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

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

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

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

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

"sneha" wrote in message
...
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.....

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

Thank you David .....

"David Biddulph" wrote:

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

"sneha" wrote in message
...
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.....