Could anybody give me any advise on accessing a chart's trendline equation via a macro, or through the API?
I've had a good dig around in the properties and methods of the 'graph' class, but can't spot anything which seems to resemble the equation.
The reason I'm after this is to provide more flexibility to the forecasting capabilities offere by the chart objects. I'm charting consumption of disk space on servers, and would like to predict how far into the future available space would drop below a certain threshold.
Each time the underlying data is updated, the trendline could potentially change it's equation, and I'd like to be able to get this changing information dynamically, rather than having to manually read and solve the trendline's equation.
