ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Slope of graph? (https://www.excelbanter.com/charts-charting-excel/47355-slope-graph.html)

LJ555555

Slope of graph?
 
How can i find the slope of a graph i drew on excel, using excel and making
the slope appear on the page with the graph itself?

Mangesh Yadav

Check the SLOPE worksheet function and use it on the data you used to plot
the graph.

Mangesh



"LJ555555" wrote in message
...
How can i find the slope of a graph i drew on excel, using excel and

making
the slope appear on the page with the graph itself?




Jerry W. Lewis

Your question is ambiguous. Mangesh mentioned the worksheet SLOPE
function. Another possible answer is from the chart Chart|Add
Trendline, and from the Options tab check Display equation on chart.

Jerry

LJ555555 wrote:

How can i find the slope of a graph i drew on excel, using excel and making
the slope appear on the page with the graph itself?



Bernard Liengme

You might want to look in Help for LINEST (I think you need to search for
'function LINEST')
This gives slope and intercept and, optionally, some vital stats about these
coefficients.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"LJ555555" wrote in message
...
How can i find the slope of a graph i drew on excel, using excel and
making
the slope appear on the page with the graph itself?





All times are GMT +1. The time now is 05:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com