Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

trying to find the slope of a trendline

Latest post Fri, Apr 18 2008 9:05 PM by br7250. 2 replies.
  • Mon, Apr 14 2008 9:23 AM

    trying to find the slope of a trendline

    I'm using Excel 2008 for mac and I have a graph with three types of data shown on it, I need to find the slope of the line for each set of individual data but I have no idea how to get this information, any help welcome!!!!!
    • Post Points: 21
  • Tue, Apr 15 2008 11:39 PM In reply to

    Re: trying to find the slope of a trendline

    Search Excel help for the SLOPE and INTERCEPT functions. Or do a Google on Excel SLOPE & INTERCEPT...

    • Post Points: 5
  • Fri, Apr 18 2008 9:05 PM In reply to

    • br7250
    • Top 25 Contributor
    • Joined on Fri, Apr 4 2008
    • Virginia, USA
    • Posts 50
    • Points 698

    Re: trying to find the slope of a trendline

     With your mouse over the data points, right click your mouse, then add the trend line option. Be sure to add the formula, the slope will then be there in the formula. I know this works with an XY graph.

    Regards,

    Bruce Reynolds

    Excel Power User and Model Developer

    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.