Trendline Equations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rpicheme07 - 20 Nov 2005 00:53 GMT

I need to know how to change the number of digits displayed on the trendline
equation. I don't think it is possible but I made an exponenital curve and
the equation they gave me is not nearly accurate enough and is certainly not
as accurate as the eqaution the program graphed!

Reply to this Message

Mike Middleton - 20 Nov 2005 01:53 GMT

rpicheme07 -

One way is to click the trendline equation (it's a special text box) to
select it and then click the Increase Decimal button repeatedly.

- Mike
www.mikemiddleton.com

>I need to know how to change the number of digits displayed on the
>trendline
[quoted text clipped - 3 lines]
> not
> as accurate as the eqaution the program graphed!

Reply to this Message

Jerry W. Lewis - 20 Nov 2005 13:22 GMT

Another way is to calculate the coefficients directly in the worksheet
http://groups.google.com/group/microsoft.public.excel.charting/msg/d955cd4118991d45

Jerry

> rpicheme07 -
>
[quoted text clipped - 11 lines]
>>not
>>as accurate as the eqaution the program graphed!

Reply to this Message