View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Bundy John Bundy is offline
external usenet poster
 
Posts: 1
Default Data Series rate of change (trend)

Check out the Slope and Intercept functions, they should get you what you need.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Mike Robinson" wrote:

On graphs, when adding trendlines, I assume that trend line is of the y=mx+b
equation. What I would like a little guidanceon is this:
Is it possible to take a series of data points and have excel calculate
slope, and intersect points...simaliar to the trend line on a graph...BUT
with out using a graph.

Any help would be greatly appreciated.

Thanks,
Mike Robinson