Ploting graident in excel

• soloken

  14 Feb 06, 10:11

  Hi,
  
  Need advice from excel experts:
  
  If I have calculated the slope which is m from the following example data:
  
  x y
  1 5
  2 7
  3 8
  
  Now I want to use the gradient from the above set to plot a chart which I have only the starting point now :
  
  x y
  1 6
  2 ?
  3 ?
  
  Please advise how can I calculate and plot for the ? in x 2 and 3?
  
  thanks.
• ndmmxiaomayi

  14 Feb 06, 11:20

  Ermm, how do you calculate gradient when you have one x and one y coordinates?
• soloken

  14 Feb 06, 13:49

  Originally posted by ndmmxiaomayi:

  Ermm, how do you calculate gradient when you have one x and one y coordinates?

  ok i manage to solve it.
  
  why not? y=mx+b and m = slope, you need to find the b and m, in this case you can use excel to find out the m using linear.
• lpx88

  14 Feb 06, 16:16

  i learn that y=mx+c in skool, where m is the gradient and C is they intercept on the y axis
• ndmmxiaomayi

  14 Feb 06, 16:38

  Originally posted by soloken:

  ok i manage to solve it.
  
  why not? y=mx+b and m = slope, you need to find the b and m, in this case you can use excel to find out the m using linear.

  But your graph is not linear. I drew out the graph, the line is a crooked.