View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
steph44haf steph44haf is offline
external usenet poster
 
Posts: 37
Default Trendline Chart Data

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