PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Trend line wont go through the origin

Reply

Trend line wont go through the origin

 
Thread Tools Rate Thread
Old 01-04-2006, 11:24 AM   #1
=?Utf-8?B?TmVvRFM=?=
Guest
 
Posts: n/a
Default Trend line wont go through the origin


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?
  Reply With Quote
Old 01-04-2006, 09:02 PM   #2
Bernard Liengme
Guest
 
Posts: n/a
Default Re: Trend line wont go through the origin

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?



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off