Finding the slope of a section of a graph in excel

  • Thread starter member 392791
  • Start date
  • #1
member 392791
Hello,

I have a graph of a tensile test of a metal sample, and I wish to find the slope on the graph of only the elastic region of the graph, meaning of the entire graph, there is only one section of it that I am interested in finding the slope for.

Is there a way in excel to make it such that you only find the slope of certain data points, as opposed to the slope of the entire graph?

Thank you
 

Answers and Replies

  • #2
Ibix
Science Advisor
Insights Author
2020 Award
7,383
6,466
I can only suggest a few hacks. I assume your elastic data is in B2:B10, and the plastic in B11:B15.

Option 1. Copy B10 into C10 and move B11:B15 into C11:C15. Plot both lines on the same chart using the same colours and point styles, and fit the elastic line. Hide the legend to conceal the implementation.

Option 2. Delete the plastic data; plot and fit the elastic data in the normal way, making sure to dispaf the equation of the line. Note down the equation, delete the chart and put the plastic data back in. Use the equation to create a column C containing the fit line and plot in the normal way.

Option 3. Do a least-squares fit yourself and plot it in the nomal way. I think Excel has SUMSQ and SUMPRODUCT functions that may prove useful in determining the parameters.
 

Related Threads on Finding the slope of a section of a graph in excel

Replies
5
Views
1K
  • Last Post
Replies
2
Views
3K
Replies
7
Views
1K
Replies
11
Views
9K
  • Last Post
Replies
6
Views
714
  • Last Post
Replies
3
Views
2K
Replies
1
Views
2K
  • Last Post
2
Replies
31
Views
3K
Replies
2
Views
3K
Top