Axes(xlValue, xlPrimary). = "ft^3/sec"ĪctiveChart.SeriesCollection(1).Trendlines.Add(Type:=xlLinear, Forward:=0, _īackward:=0, DisplayEquation:=True).SelectĪctiveChart.SeriesCollection(1).Trendlines(1). Axes(xlValue, xlPrimary).HasTitle = True where: a and b are the parameters of the approximating function (also named function coefficients or constants ), e is the mathematical constant, the base of the natural logarithm (also known as Eulers number. The exponential trendline is a curved line described by the function: y a ebx. Axes(xlCategory, xlPrimary).HasTitle = True Exponential trendline equation and formulas. Any help would be very much appreciated,ĪctiveChart.SetSourceData Source:=Sheets("Sheet1").Range("C2:C57,E2:E57"), _ĪctiveChart.SeriesCollection(1).XValues = "=Sheet1!R2C5:R57C5"ĪctiveChart.SeriesCollection(1).Values = "=Sheet1!R2C3:R57C3"ĪctiveChart.Location Where:=xlLocationAsNewSheet 2 lraio, Welcome to the board Not exactly 'automatic', but if you select the trendline, right click, select options & click the box 'display equation on chart', you get to see the equation.
The code which creates the graph is shown below. I need to disaply the values of an equation of a trendline in seperate cells in the worksheet for further caluculations, therefore I won't have to keep doing it manually each time.
0 kommentar(er)
