Thread: How to Show/calculate End-values of Trendline?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
  
Posts: 563
Default How to Show/calculate End-values of Trendline?
The b parameter (the "intercept" ) is value of y at x=0 (where the line
crosses the y axis). It is not really an 'end'. To compute the value of y at
any other value of x (let's say at a value of x stored in G3) use =slope*G1
+ intercept. Now you could copy the slope and intercept values from the chart
but you are better off using the SLOPE and INTERCEPT function. Read about
these in Help and them post a new mesage to get more help.
best wishes
--
www.stfx.ca/people/bliengme


"H. Forstner" wrote:

Hello,

(Excel 2007)

I created a graph and a linear trendline, showing the equation:
y = mx+b

B determines the starting point.

How can I get the value of the end of the trendline?


Thanks for your help

rgds
Harry




Reply With QuoteReply With Quote