how can you calulate the slope of a trend line

S

Sue

Any advice on this would be graetfully received. I have set trend lines and
now wish to calculate an overalll % increase or decrease in the slope
 
M

MartinW

Hi Sue,

John Walkenbach shows all the equations here.
http://j-walk.com/ss///excel/tips/tip101.htm

You also may want to check out the TREND and FORECAST
functions in the helpfile.

Post back if you are having trouble applying them.
Don't forget to include details of your data and
what you are trying to achieve.

HTH
Martin
 
J

Jon Peltier

If you have a trendline, you can right click on it, choose Format, and on
the Options tab, check Show Formula on Chart. Increase the decimals in the
formula (use the Increase Decimals button or right click the formula, choose
Format, and on the Number tab choose a Number format with lots of decimal
places or a scientific format with lots of decimal places). Pick your slope
from the modified formula. Or use the SLOPE worksheet function on the chart
data in the worksheet to calculate the slope more directly.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the slope of line graph with the use of spinbutton in Excel VBA 1
Changing angle of trend line. 1
How do I show slope on a chart? 6
How to graph a slope? 1
Slope of a Trend Line 1
Lines of a particular slope that can be moved around 2
How do I determine the slope of a logarithmic scale data plot? 1
How to recognize changes in slope of data? 2

Top