![]() ![]() Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. Set chrt ActiveChart chrt.ChartType xlLine Get a series. For example, the following code adds a trendline to the first series in a chart: Sub AddTrendline ( ) Dim chrt As Chart, tl As Trendline, tls As Trendlines Get the chart. This data is not confidential or proprietary. Trendlines apply to a single series, so you add them using the Series object’s Trendlines property. ![]() I'm open to any information you guys are willing to offer, and, as always, I am eager to learn.įor your convenience, a portion of the data graphed to obtain the trendline is provided below (excluding the non-linear portion of the graph). Also, I'm not entirely sure how to access a chart object on a worksheet. ![]() I was unable to find anything to reference the trendline. I looked through the object browser and found a Chart class (not the ChartObject class) which contained several chart properties and methods. I would like to write a macro that will extract this slope from the trendline of the graph. We are graphing some fuel cell data and using the slope to determine internal resistance, R-ohm. Have an interesting problem that I need some help with. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |