Insure that the Analysis ToolPak has been loaded. If your data is linear,
then use LINEST() to derive the formula
--
Gary's Student


"rmellison" wrote:

If I have a set of data, is there any way I can generate a formula which
roughly matches the plot of the data set? I know I can generate a trend line
on a chart but is there a way of finding out the formula for this trendline,
so that I could reproduce it without the origiinal data perhaps?

Hope I'm making myself clear. Many thanks in advance.