Hi-
I need to add a trendline to my plot of sinusoidal data, but Excel only
gives 6 options (linear, logarithmic, polynomial, power, exponential,
and moving average). Does anyone know of a plugin, preferably free,
that lets one add a Sine trendline?
Thanks!
-Jess
Jim Gordon MVP - 23 Aug 2005 00:19 GMT
Hi,
I found just what you are looking for!
First I went to http://www.mathtools.net/ and found Emil Meyer's
Trigo_8e download. You have to use Stuffit Expander on the file twice to
get the folder from the exe executable.
When you've expanded it all the way you'll find the add-in Trigono.xla
which worked fine for me in Excel 2004.
-Jim

Signature
Jim Gordon
Mac MVP
MVP FAQ
<http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs>
> Hi-
>
[quoted text clipped - 6 lines]
>
> -Jess
jessriedel@gmail.com - 23 Aug 2005 22:44 GMT
Perhaps I'm doing this wrong, but it looks like this is only a
collection of trig functions (e.g. a function to display the result of
arctan in degrees and minutes instead of decimal degrees). It does
not, to the best of my knowledge, allow one to add a sinusoidal
trendline by right clicking on scatter plot points and selecting "add
trendline".
Thanks!
Jim Gordon MVP - 24 Aug 2005 01:14 GMT
And here I thought I had it! Oh well.
There is an entire newsgroup devoted to charting. It's
microsoft.public.excel.charting
Maybe there will be someone in that group who has experience with what
you are seeking. Please consider posting your request there.
-Jim

Signature
Jim Gordon
Mac MVP
MVP FAQ
<http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs>
> Perhaps I'm doing this wrong, but it looks like this is only a
> collection of trig functions (e.g. a function to display the result of
[quoted text clipped - 4 lines]
>
> Thanks!