^{1,2} assumes that the data are in columns. Use ^{1;2} if the data are in
rows.

Jerry

"steph44haf" wrote:

Mike,

I am having trouble with the ^{1,2} part of the Trend equation. I get an
error when I put that in. I know I must be doing something wrong.

Can you help?

Thanks,

Stephanie

"Mike Middleton" wrote:

Stephanie -

Did you look at the LinearTrendSeasonalForecast.xls workbook that I posted
for you at www.mikemiddleton.com ?

The "3 Visual Check Trend" worksheet has a linear trendline, and the "5
Trend and Ratios" worksheet uses the array-entered TREND worksheet function
to obtain the same points in worksheet cells.

- Mike

"steph44haf" wrote in message
...
Hi,

Besides guessing, can I get the data points from my Trendline on my Chart?
I am looking for amounts from the Trendline.

Thanks,

Stephanie