Charts: Can you fit trendline

lambuhere1 · Aug 12th 2003

Hi

I am trying to fit a trend line for a chart in the attached workbook, OTHER THAN MOVING AVERAGES.

Can anyone help me in fitting a trendline?

Thanks

Ram P

Anonymous · Aug 12th 2003

All of your y values are identical, so the trend is obvious. In general, you can use the Chart menu to add a trendline using various regression forms. What is it that you are seeking?

lambuhere1 · Aug 12th 2003

Derk,

Thanks for your reply. But I am not able to FIT any trendline. Probably you can have a shot at it. Hence this post for help.

Anonymous · Aug 12th 2003

Excel has a small numerical accuracy problem when all of the Y values are the same. I changed a couple of your values and inserted a linear trend line for the data. Does this help?

Charts: Can you fit trendline

Participate now!

Share