Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Results of trend line in Excel | Charts and Charting in Excel | |||
Quantify trend line | Excel Discussion (Misc queries) | |||
Getting values from a trend line | Excel Discussion (Misc queries) | |||
How do I anchor one end of a linear trend line? | Charts and Charting in Excel | |||
trend line does not appear | Charts and Charting in Excel |