Object 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 Note: If you have a current version of Microsoft 365, then you can input the formula in. TREND returns the y-values along that line for the array of newx's that you specify. It fits a straight line (using the method of least squares) to the array's knowny's and knownx's. I want to do it for all existing trendlines in all sheets and charts. The TREND function returns values along a linear trend. Sometimes it happens that the trendline label in excel isn't updated when I changed the graph-data.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |