Does anyone know how, given a data set, I can pull out the equation of the trendline without having to plot the chart and visually type in the code?
I have to perform this and build up equations for best fits for around 500 data arrays - so am in great need for an automated process. I dont believe the data anlaysis regression tool would also be suited (unless there is a way of accesing this from VBA which I am not aware of).

I would appreciate your help.

Many thanks,
Tanveer.