Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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.....
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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.....



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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.....




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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.....






  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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.....








  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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.....








  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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.....




  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,393
Default 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.....



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Returning a distance from a tabel, given "from" and "To"? Max Excel Worksheet Functions 4 June 21st 06 11:52 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
Stop my "combo box" from changing locations after print previewin. murphytsa Excel Discussion (Misc queries) 2 February 17th 06 06:37 PM


All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"