Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sine wave trendline | Charts and Charting in Excel | |||
different color on scatter plot separated by a trendline | Charts and Charting in Excel | |||
Scatter Plot with Trendline and equation | Excel Discussion (Misc queries) | |||
How do I floodfill excel scatter charts only below the trendline? | Charts and Charting in Excel | |||
sine wave trendline | Excel Discussion (Misc queries) |