Function TrendLineValue (x As Double) As Double Dim c As Chart Dim t As Trendline Dim s As String Get the trend line object this code assumes the first chart on the active sheet, and the first series, first. To display the trendline equation, click Show equation, and then click Show in legend or Show on chart, and then click Position to define the equations. To change the number of decimal places in the trendline equation, right-click on the. You can write a vba user defined function to use the trend line formula to evaluate a given x. Python Dictionaries Access Items Change Items Add Items Remove Items Loop Dictionaries Copy Dictionaries Nested Dictionaries Dictionary Methods Dictionary Exercise Python If.Else Python While Loops Python For Loops Python Functions Python Lambda Python Arrays Python Classes/Objects Python Inheritance Python Iterators Python Polymorphism Python Scope Python Modules Python Dates Python Math Python JSON Python RegEx Python PIP Python Try. You can use the trendline from a graph in an equation, but, in addition to translating it correctly, you need to also format the trendline to show a maximum number of decimals (e.g 15), else your results will not be congruent with the graph. Then check the Display Equation on chart box.
