PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Trend line wont go through the origin
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Trend line wont go through the origin
![]() |
Trend line wont go through the origin |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
I'm doing my chemistry coursework, but when I enter the data and make a
trendline, the trendline doesn't start at x=0, y=0. how can I do this? |
|
|
|
#2 |
|
Guest
Posts: n/a
|
Look in the Trendline Options tab; you can specify the value required fro
the intercept - in your case 0 To get the slope's value into a cell, do not copy the trendline equation but rather use the SLOPE function. I am assuming you have a linear expression (must graphs I used in teaching chem were linear); if no see my website to learn about LINEST. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "NeoDS" <NeoDS@discussions.microsoft.com> wrote in message news:C7EEF9E1-C85E-44F6-9154-9587C38E098F@microsoft.com... > I'm doing my chemistry coursework, but when I enter the data and make a > trendline, the trendline doesn't start at x=0, y=0. how can I do this? |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

