![]() 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 Axes(xlCategory, xlPrimary).HasTitle = True 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 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. How to add an equation to the trendline or line of best fit in Microsoft Excel In the options Format Trendline, tick the checkbox that asks to Display Equation on Chart, this will.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |