PC Review


Reply
Thread Tools Rate Thread

how do i find the slope of a line in excel?

 
 
=?Utf-8?B?Y29saW4gbWNjcmVhZHk=?=
Guest
Posts: n/a
 
      24th Sep 2007

 
Reply With Quote
 
 
 
 
JE McGimpsey
Guest
Posts: n/a
 
      24th Sep 2007
What are you starting with?

If you have two points, say, (x1,y1) in A1:B1 and (x2,y2) in A2:B2 then
the slope in C1 is returned by

C1: =(B2-B1)/(A2-A1)

In article <17CDC620-B55F-4B1D-9795-(E-Mail Removed)>,
colin mccready <colin (E-Mail Removed)> wrote:
 
Reply With Quote
 
Bernard Liengme
Guest
Posts: n/a
 
      24th Sep 2007
1) By making an XY chart and inserting a trendline with the equation
displayed
or
2) By using the SLOPE function

Have you experimented using Excel's Help feature - it is very useful
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"colin mccready" <colin (E-Mail Removed)> wrote in message
news:17CDC620-B55F-4B1D-9795-(E-Mail Removed)...
>



 
Reply With Quote
 
Bob I
Guest
Posts: n/a
 
      24th Sep 2007
See Help, Slope.

colin mccready wrote:

 
Reply With Quote
 
David Biddulph
Guest
Posts: n/a
 
      24th Sep 2007
Firstly, the purpose of the message body is to allow you to ask the
question. Don't just put it in the subject line. Blank messages are often
rejected or ignored.

Secondly, why not be brave and type the word "slope" into excel help and see
what you find? [A more blunt answer would be RTFM]
--
David Biddulph

"colin mccready" <colin (E-Mail Removed)> wrote in message
news:17CDC620-B55F-4B1D-9795-(E-Mail Removed)...
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i find the slope of a graph in excel? Tunav Microsoft Excel Charting 2 27th Jan 2009 08:30 AM
how can you calulate the slope of a trend line Sue Microsoft Excel Charting 2 7th Mar 2008 12:34 PM
Slope line in stacked area chart =?Utf-8?B?ampidWQ0NA==?= Microsoft Excel Charting 3 15th May 2007 08:12 PM
Adding a slope line to a graph =?Utf-8?B?YnVkZHlsZWUyNTA2?= Microsoft Excel Misc 1 13th Apr 2007 07:24 PM
Slope of a Trend Line jpx Microsoft Excel Misc 1 24th Apr 2006 10:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:41 PM.