Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can you calulate the slope of a trend line
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can you calulate the slope of a trend line
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 "Sue" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can you calulate the slope of a trend line
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sue" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i find the slope of a line in excel? | Excel Discussion (Misc queries) | |||
Slope line in stacked area chart | Charts and Charting in Excel | |||
Adding a slope line to a graph | Excel Discussion (Misc queries) | |||
How to make tangent line/slope on exponential curve? | Excel Discussion (Misc queries) | |||
Slope of a Trend Line | Excel Discussion (Misc queries) |