Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Returning a distance from a tabel, given "from" and "To"? | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Stop my "combo box" from changing locations after print previewin. | Excel Discussion (Misc queries) |