+ Reply to Thread
Results 1 to 2 of 2

Slope of a Trend Line

  1. #1
    Registered User
    Join Date
    09-23-2003
    Posts
    18

    Slope of a Trend Line

    I have added a linear trend line to a graph. Is it possible to see the slope and intercept somehow??

  2. #2
    MartinW
    Guest

    Re: Slope of a Trend Line

    Hi jpx,

    Right click on the trend line and go to Format Trendline>Options tab and
    click "show equation on chart". This will bring up the values for Y=Mx + C.

    To get the the value of M in a cell use SLOPE and to get the value of C use
    INTERCEPT, selecting the x + y range the same as you did for your data
    points.

    HTH
    Martin



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1