#1
hi, as u can see in the pic, i hav a graph from a charpy fracture test. The problem is hte line through the graph is simply a line-scatter graph. But i need to make the line a smooth trendline that looks like a sideways tan graph. Anybody know how to do this?

tldr, i need to make an actual trendline that goes smoothly through the points

Sell and Promote your music TuneHub!



wy is yer mad at muy gramhar fer?


Quote by jimmyled
jimmybanks youre a genius.


aparently i ar smrt?
Quote by dyingLeper
jimmybanks youre a genius


GO SENS GO
#2
k so iv still gotten the same thing, but i made the graph more clear and added in a Transit T value which can be seen on the far right, i need to get a line to develop that goes from that toughness value to the graph, then drops to a Temperature value, anybody know how to do this?
Sell and Promote your music TuneHub!



wy is yer mad at muy gramhar fer?


Quote by jimmyled
jimmybanks youre a genius.


aparently i ar smrt?
Quote by dyingLeper
jimmybanks youre a genius


GO SENS GO
#3
click on the line that joins your point to select it.
now right click on it...
click add trendline..
select the type you want..

excel does it all, and displays the line equation too.
#4
Quote by voodoochild13
click on the line that joins your point to select it.
now right click on it...
click add trendline..
select the type you want..

excel does it all, and displays the line equation too.


well iv tried this, but none are correct, the closest is a 3rd polynomial, but this is not what is needed

it needs to be a smooth average that curves through the points kind of trendline, maybe excel cannot do this but i thought my TA said it did.
Sell and Promote your music TuneHub!



wy is yer mad at muy gramhar fer?


Quote by jimmyled
jimmybanks youre a genius.


aparently i ar smrt?
Quote by dyingLeper
jimmybanks youre a genius


GO SENS GO
#5
shameless bump, any help appreciated
Sell and Promote your music TuneHub!



wy is yer mad at muy gramhar fer?


Quote by jimmyled
jimmybanks youre a genius.


aparently i ar smrt?
Quote by dyingLeper
jimmybanks youre a genius


GO SENS GO
#6
You could make a new data series that's a hyperbolic tangent, i.e. y = tanh(x), and fiddle with the numbers so it sits in the right place on your graph. Bit of a mission but should get what you want. No idea if there's a quicker way though.

Also it almost certainly won't be able to go through all of your data points, but should be close enough, at least passing through the error bars.