![]() ![]() ![]() In lines above these (not included), the series are added, trendlines inserted, and DisplayEquation is called for each trendline. ![]() The CDbl(Mid()) is used to trim TLEq to just the slope and convert to a Double. TLEq is a string to temporarily hold the full text of the trendline equation (intercept set to 0 so simple y = mx equation). SelectedSheets is an array filled with the sheets the user selects to be analyzed from a multi-select userform listbox. ModulusArr(j) = CDbl(Mid(TLEq, 4, Len(TLEq) - 4)) I want to report the slope average of all the trendlines and I've written the code below to do this action: For j = 1 To UBound(SelectedSheets) I've had success with everything except extracting the trendline slopes. I'm currently making a macro to extract raw data from multiple csvs, print it in different sheets, trim extraneous data, plot data from each sheet on a single graph with individual trendlines, and report some information for said trendlines and data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |