Trend Line Values In Excel

sir_william

New Member
Joined
Jan 19, 2005
Messages
14
I am an analyst at an Oil company. We plot hyperbolic decline production curves in excel, however I am wondering if there is a way to collect the values that are based on the trendline curve. The thought of this is to use these data values as a sort of interpolation curve for errors in the data.

Does anyone know how to extract the values that a trenline is made up of?
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

a7n9

Well-known Member
Joined
Sep 15, 2004
Messages
696
If you're using the trendlines from Excel on a scatter plot, then just select the trendline from the plot, right click>>Format Trendline>>Go to Options>>Check the box for "Display equation on Chart"

Hope this helps
 

sir_william

New Member
Joined
Jan 19, 2005
Messages
14
Well, that helps in a way.

I was hoping that the simplicity of the trendline was represented in excel by *creating a virtual array of numbers based on that equation that I could extract then drop in column B (where the source data would be in column A, rather than Excel drawing a curve from a mathmatical calculation.

This makes sense though... but still wish that there would be an option to convert that trend equation to raw numbers in an array for me that I could simply copy without further computation.
 

a7n9

Well-known Member
Joined
Sep 15, 2004
Messages
696
There are functions like: LINEST (linear), LOGEST (Exponential), TREND (to predict). However, it cannot calculate hyperbolic trendline function, in my knowledge.

Also, you can copy that equation from the chart and put in column B, then all you have to change is the X and Y

If you know the algorithm of fitting Hyperbolic, we can try to create that function.

Check these links at MS:
http://office.microsoft.com/en-us/assistance/HA011118881033.aspx
http://office.microsoft.com/en-us/assistance/HA011416701033.aspx
http://office.microsoft.com/en-us/assistance/HA010929231033.aspx
 

Watch MrExcel Video

Forum statistics

Threads
1,123,349
Messages
5,601,116
Members
414,429
Latest member
Bilaal xaka

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top