7/28/2023 0 Comments Excel vba get trendline equationObject doesn't support this property or method in the line with the error comment. Set oChart = Sheets(nSheet).ChartObjects(nChart)ĪctiveChart.SeriesCollection(1).Trendlines(1).Select 'Debug.Print Sheets(nSheet).ChartObjects(nChart).SeriesCollection.Countĭo While nSeriesCollection <= Sheets(nSheet).ChartObjects(nChart).SeriesCollection.Countĭebug.Print "nSheet: " & nSheet & " nChart: " & nChart ![]() Sub Auto_Open()ĭim oChart As ChartObject, nSheet As Integer, nChart As Integerĭo While nChart <= Sheets(nSheet).ChartObjects.Count I want to do it for all existing trendlines in all sheets and charts. ![]() ![]() Add ( Type, Order, Period, Forward, Backward, Intercept, DisplayEquation, DisplayRSquared, Name) ActiveWorkbook.Charts('Chart1').SeriesCollection(1).Trendlines. ![]() Sometimes it happens that the trendline label in excel isn't updated when I changed the graph-data. Add Trendlines.Add (Excel) Creates a new trendline.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |