Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 16th 09, 11:14 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 2
Default Sine trendline in scatter?

Hi,

I admit I'm not well versed with Excel 2007, but it doesn't appear that I
can add a sine trend line to my scatter point chart and I need to. Is there a
way to do this or perhaps an add-on that adds it to the trendline-type menu?

Thanks,
Thora

  #2   Report Post  
Old May 17th 09, 02:43 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 1,104
Default Sine trendline in scatter?

You will need to do this using Solver
Send me (private email - just remove TRUENORTH.) a file with sample data and
tell me the form of the equation to be used in the fit (example: y=Asin(Bx)
where A and B are to be determined)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Thora" wrote in message
...
Hi,

I admit I'm not well versed with Excel 2007, but it doesn't appear that I
can add a sine trend line to my scatter point chart and I need to. Is
there a
way to do this or perhaps an add-on that adds it to the trendline-type
menu?

Thanks,
Thora



  #3   Report Post  
Old May 17th 09, 07:37 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 2
Default Sine trendline in scatter?

Hi,

Sorry I didn't see an email with caps to remove...so I thought it easiest
just to upload it externally. I hope that's okay. It's .xls

http://www.filedropper.com/sampledataneedssinetrend

The file contains two sets of data, the first is an obvious sine curve
trend, and the second sheet is a much less obvious sine trend (and the real
difficulty, as I can't freehand it). There are a few instances where there is
no data for Y; ignoring those should be fine, I should think.

As for the equation form...it's been so long since I've had to do any of
this... y=Asin(BX) is probably the best I can offer.

Thank you very mych for your assistance!

Thora



"Bernard Liengme" wrote:

You will need to do this using Solver
Send me (private email - just remove TRUENORTH.) a file with sample data and
tell me the form of the equation to be used in the fit (example: y=Asin(Bx)
where A and B are to be determined)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Thora" wrote in message
...
Hi,

I admit I'm not well versed with Excel 2007, but it doesn't appear that I
can add a sine trend line to my scatter point chart and I need to. Is
there a
way to do this or perhaps an add-on that adds it to the trendline-type
menu?

Thanks,
Thora




  #4   Report Post  
Old May 19th 09, 08:01 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 4
Default Sine trendline in scatter?

What's "Solver"?

Thanks.
--
Royi Avital


"Bernard Liengme" wrote:

You will need to do this using Solver
Send me (private email - just remove TRUENORTH.) a file with sample data and
tell me the form of the equation to be used in the fit (example: y=Asin(Bx)
where A and B are to be determined)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Thora" wrote in message
...
Hi,

I admit I'm not well versed with Excel 2007, but it doesn't appear that I
can add a sine trend line to my scatter point chart and I need to. Is
there a
way to do this or perhaps an add-on that adds it to the trendline-type
menu?

Thanks,
Thora




  #5   Report Post  
Old May 19th 09, 08:49 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default Sine trendline in scatter?

If Excel help isn't working on your machine, you may need to reinstall
Excel.
--
David Biddulph

Royi Avital wrote:
What's "Solver"?

Thanks.

You will need to do this using Solver
Send me (private email - just remove TRUENORTH.) a file with sample
data and tell me the form of the equation to be used in the fit
(example: y=Asin(Bx) where A and B are to be determined)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Thora" wrote in message
...
Hi,

I admit I'm not well versed with Excel 2007, but it doesn't appear
that I can add a sine trend line to my scatter point chart and I
need to. Is there a
way to do this or perhaps an add-on that adds it to the
trendline-type menu?

Thanks,
Thora





  #6   Report Post  
Old May 19th 09, 01:53 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 1,104
Default Sine trendline in scatter?

If you look at this email you will see my address with TRUENORTH. added to
it
Or visit my website
I could not get the file from your site; also I need somewhere to send my
reply file
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Thora" wrote in message
...
Hi,

Sorry I didn't see an email with caps to remove...so I thought it easiest
just to upload it externally. I hope that's okay. It's .xls

http://www.filedropper.com/sampledataneedssinetrend

The file contains two sets of data, the first is an obvious sine curve
trend, and the second sheet is a much less obvious sine trend (and the
real
difficulty, as I can't freehand it). There are a few instances where there
is
no data for Y; ignoring those should be fine, I should think.

As for the equation form...it's been so long since I've had to do any of
this... y=Asin(BX) is probably the best I can offer.

Thank you very mych for your assistance!

Thora



"Bernard Liengme" wrote:

You will need to do this using Solver
Send me (private email - just remove TRUENORTH.) a file with sample data
and
tell me the form of the equation to be used in the fit (example:
y=Asin(Bx)
where A and B are to be determined)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Thora" wrote in message
...
Hi,

I admit I'm not well versed with Excel 2007, but it doesn't appear that
I
can add a sine trend line to my scatter point chart and I need to. Is
there a
way to do this or perhaps an add-on that adds it to the trendline-type
menu?

Thanks,
Thora








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
different color on scatter plot separated by a trendline Laoballer Charts and Charting in Excel 1 January 31st 09 08:03 AM
Scatter Plot with Trendline and equation jfg Excel Discussion (Misc queries) 1 February 7th 08 12:41 PM
How do I floodfill excel scatter charts only below the trendline? RWB7s Charts and Charting in Excel 2 March 12th 06 04:31 PM
sine wave trendline Amedee Van Gasse Charts and Charting in Excel 7 July 29th 05 08:35 AM
sine wave trendline Amedee Van Gasse Excel Discussion (Misc queries) 10 July 12th 05 04:01 PM


All times are GMT +1. The time now is 05:43 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017