![]() |
|
|
|
#1
|
|||
|
|||
|
The y-intercept is part of the equation. The x-intercept can be derived from the equation by setting y=0. Is that what you want? |
|
#2
|
|||
|
|||
|
Quote:
On the chart, there is the x-y equation which is automatically generated in making the scatter chart. However, we cannot take out the x-y equation. If I want to use it in a cell, I have to manually type the x-y equation provided on the chart (e.g. y = 0.548x + 1.369) in that cell. But anyway, it seems that I've found a solution. In that cell, I manually type an equation: y = mx + b where m = slope and b = interception and that equation is the same to that generated from the scatter chart. However, a question is still unanswered. That is - how can I get the interception between the markers and the trendline on the scatter chart? |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Linear trendline? | markg2 | Excel | 0 | 06-25-2015 05:19 AM |
| 2 different indent markers | mekd | PowerPoint | 0 | 10-12-2013 06:59 AM |
| Chart Markers on PPT | zymolysis | PowerPoint | 0 | 06-21-2012 07:54 PM |
Can't get rid of Margin Markers and need to get rid of them
|
APohlmeyer | Word | 1 | 12-21-2011 04:06 PM |
Additional Markers in 2010(?)
|
judicial85 | Excel | 5 | 09-26-2011 08:06 AM |