- **Charts and Charting in Excel**
(*https://www.excelbanter.com/charts-charting-excel/*)

- - **Sine trendline in scatter?**
(*https://www.excelbanter.com/charts-charting-excel/231068-sine-trendline-scatter.html*)

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 |

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 |

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 |

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 |

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 |

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 |

All times are GMT +1. The time now is 05:00 AM. |

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.

ExcelBanter.com