![]() 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). 3 Answers Sorted by: 33 Ive been looking for this formula in this website so Ive made it Q&A style :) Hope this helps. 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. ![]() 1 Workbook workbook new Workbook () 2 workbook.LoadFromFile ('Sample. 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. Step 1: Instantiate a Workbook object and load the Excel document.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |