I have a set of data to which I've fit a trendline on my chart. I'm currently using the option to calculate the line with a custom intercept (0), and for the graphing tool this works fine. However, I need to report that slope for some other calculations in my spreadsheet and I would a way to calculate it in a cell. Obviously excel has the power to do this, since it does it for the chart, but I haven't been able to find any built-in functions that can do this.
Is there a function that I can choose to do this with (SLOPE() doesn't give me the choice), or is there some way that I can pull the slope value on the chart label into a or cell or even a formula (this would be more helpful to what I'm doing)?
Is there a function that I can choose to do this with (SLOPE() doesn't give me the choice), or is there some way that I can pull the slope value on the chart label into a or cell or even a formula (this would be more helpful to what I'm doing)?
