ClioSport.net

Register a free account today to become a member!
Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

  • When you purchase through links on our site, we may earn an affiliate commission. Read more here.

HELP: Trendlines in MS Excel



  Clio 197
Evening!

I have a few graphs in MS Excel, with trendlines.

I'd like to analyse the trends, so as to compare the growth on various graphs.

IE I want to compare the trendlines to each other. Is there a way to get Excel to tell me the angle of the trendlines at all?
 
It can show formulas for trent lines ie y = x+8 etc. However its always a complex line equation when I do it.
 
  R35 GTR
Evening!

I have a few graphs in MS Excel, with trendlines.

I'd like to analyse the trends, so as to compare the growth on various graphs.

IE I want to compare the trendlines to each other. Is there a way to get Excel to tell me the angle of the trendlines at all?
no easy way i know of. Set trendline, display equation, then the gradient is the multiple of x, assuming it's a linear equation.
 
  Clio 197
Ta.

I've got the slope now (m), so that's what I wanted basically.

All my graphs have the same X scale, so the slope (y=mX + C) is comparable.

:)
 


Top